Working With Measures
Note:
Measures are dynamic calculations that provide meaningful insights into the dataset. They are created using Data Analysis Expressions (DAX), a powerful formula language designed specifically for working with data in Power BI. Measures are commonly used in reports and visualizations to perform aggregations, comparisons, or other calculations based on the data in your model.
The following are some examples of using measures:
| • | #Installs = COUNT( 'Installed Software'[Id]) |
| • | #Devices = COUNT( 'Device'[Id]) |
You can easily drag and drop measures into your visuals to create an interactive and insightful report. To help you identify measures, the Measures suffix is added to their names in the corresponding table. The following tables contain measures:
| • | Device Measures |
| • | Software Measures |
| • | Vulnerability Measures |
Note:Not all measures are visible by default. Some measures are hidden and can be enabled upon request. If you would like the measures enabled, contact Flexera Support. For more information, see Contacting Flexera Support.
You can create a report based on their types: Hardware, Software, or Vulnerabilities.
| • | When creating a Hardware report, the Device and Virtual Machine tables act as a joining link between all other tables. There is no direct relationship between the Device and Virtual Machine tables. As a result avoid using fields from both tables in a single visual. |
For example, use the #Devices measure listed in the Device Measures table and for virtual machine information, use the #Virtual Machine measure listed in the Device Measures table.
| • | When creating a Software report, the Installed Software table is the joining link between all other tables. Therefore, it is recommended to use the #Installs measure from the Software Measures table to create a visual. |
| • | When creating a Vulnerabilities report, the Vulnerability and Vulnerability Advisory tables act as a joining link between all other tables. There is no direct relationship between the Vulnerability and Vulnerability Advisory tables. As a result avoid using fields from both tables in a single visual. |
For example, for Secunia-related information, use the Total Vulnerabilities with Secunia Advisory measure listed in the Secunia Advisory sub folder and for vulnerabilities related information, use the Total Vulnerabilities measure listed in the Vulnerability sub folder. Both Secunia Advisory and Vulnerability sub folders are listed in the Vulnerability Measures table.
This section includes the following subsections:
| • | Measures Available for Hardware Report Type |
| • | Measures Hidden for Hardware Report Type |
| • | Measures Available for Software Report Type |
| • | Measures Hidden for Software Report Type |
| • | Measures Available for Vulnerabilities Report Type |
Measures Available for Hardware Report Type
The following table lists the measures that are available in the tables for the Hardware report type:
|
Measure Name |
Table Name |
Sub Folder |
|
#Devices End of Sale Over Time |
Device Measures |
Date Measures |
|
#Devices Obsolete Over Time |
Device Measures |
Date Measures |
|
#Hardware Models End of Sale Over Time |
Device Measures |
Date Measures |
|
#Hardware Models Obsolete Over Time |
Device Measures |
Date Measures |
|
#Hardware Products End of Sale Over Time |
Device Measures |
Date Measures |
|
#Hardware Products Obsolete Over Time |
Device Measures |
Date Measures |
|
#Devices |
Device Measures |
None |
|
#Devices End of Sale |
Device Measures |
None |
|
#Devices GA |
Device Measures |
None |
|
#Devices Missing Model Information |
Device Measures |
None |
|
#Devices Obsolete |
Device Measures |
None |
|
#Devices Unpublished Lifecycle |
Device Measures |
None |
|
#Devices Virtual System |
Device Measures |
None |
|
#Hardware Categories |
Device Measures |
None |
|
#Hardware Manufacturers |
Device Measures |
None |
|
#Hardware Models |
Device Measures |
None |
|
#Hardware Models GA |
Device Measures |
None |
|
#Hardware Models End of Sale |
Device Measures |
None |
|
#Hardware Models Obsolete |
Device Measures |
None |
|
#Hardware Products |
Device Measures |
None |
|
#Hardware Products Virtual |
Device Measures |
None |
|
#Hardware Subcategories |
Device Measures |
None |
|
#Locations |
Device Measures |
None |
|
Devices End of Sale % |
Device Measures |
None |
|
Devices GA % |
Device Measures |
None |
|
Devices Missing Model Information % |
Device Measures |
None |
|
Devices Obsolete % |
Device Measures |
None |
|
Devices Obsolete in Past % |
Device Measures |
None |
|
Devices Unpublished Lifecycle % |
Device Measures |
None |
|
Devices Virtual % |
Device Measures |
None |
|
Model to Product Ratio |
Device Measures |
None |
|
Average Clock Speed |
Device Measures |
Processor |
|
Total Core Count |
Device Measures |
Processor |
|
Total Logical Count |
Device Measures |
Processor |
|
Average Green Score |
Device Measures |
Sustainability |
|
Average kgCO2e Per Year |
Device Measures |
Sustainability |
|
Average of kWhr Per Year |
Device Measures |
Sustainability |
|
Average PUE |
Device Measures |
Sustainability |
|
Cloud Emissions Daily Output (kgCO2e) |
Device Measures |
Sustainability |
|
Cloud Emissions Daily Savings (kgCO2e) |
Device Measures |
Sustainability |
|
Daily Emissions kgCO2e |
Device Measures |
Sustainability |
|
Device kgCO2e - Scope 1 |
Device Measures |
Sustainability |
|
Device kgCO2e - Scope 2 |
Device Measures |
Sustainability |
|
Device kgCO2e - Scope 3 |
Device Measures |
Sustainability |
|
Device kgCO2e - Total |
Device Measures |
Sustainability |
|
Electricity Consumed (kWh) |
Device Measures |
Sustainability |
|
Miles Driven Each Year |
Device Measures |
Sustainability |
|
Miles Driven Each Year (Cloud) |
Device Measures |
Sustainability |
|
Miles in a Car |
Device Measures |
Sustainability |
|
Miles Saved |
Device Measures |
Sustainability |
|
Original Server Count |
Device Measures |
Sustainability |
|
Total Devices LatestDate |
Device Measures |
Time Series |
|
Total EOS LatestDate |
Device Measures |
Time Series |
|
Total OBS LatestDate |
Device Measures |
Time Series |
|
#Hardware Manufacturers Host |
Device Measures |
Virtualization |
|
#Hardware Manufacturers VM |
Device Measures |
Virtualization |
|
#Hardware Models Host |
Device Measures |
Virtualization |
|
#Hardware Models VM |
Device Measures |
Virtualization |
|
#Hardware Products Host |
Device Measures |
Virtualization |
|
#Hardware Products VM |
Device Measures |
Virtualization |
|
#Host |
Device Measures |
Virtualization |
|
#Virtual Machine |
Device Measures |
Virtualization |
|
#Software Releases Obsolete Over Time |
Software Measures |
Date Measure |
|
#Installs |
Software Measures |
None |
|
#Installs EOL |
Software Measures |
None |
|
#Installs GA |
Software Measures |
None |
|
#Installs Missing Version Information |
Software Measures |
None |
|
#Installs Obsolete |
Software Measures |
None |
|
#Installs Open Source Support |
Software Measures |
None |
|
#Installs Unpublished Lifecycle |
Software Measures |
None |
|
#Software Categories |
Software Measures |
None |
|
#Software Manufacturers |
Device Measures |
None |
|
#Software Products |
Software Measures |
None |
|
#Software Releases |
Software Measures |
None |
|
#Software Subcategories |
Software Measures |
None |
|
#Versions |
Software Measures |
None |
|
Version to Product Ratio |
Software Measures |
None |
|
#Installs Host |
Software Measures |
Virtualization |
|
#Installs VM |
Software Measures |
Virtualization |
|
#Software Manufacturers Host |
Software Measures |
Virtualization |
|
#Software Manufacturers VM |
Software Measures |
Virtualization |
|
#Software Products Host |
Software Measures |
Virtualization |
|
#Software Products VM |
Software Measures |
Virtualization |
|
#Software Releases Host |
Software Measures |
Virtualization |
|
#Software Releases VM |
Software Measures |
Virtualization |
|
#Software Versions Host |
Software Measures |
Virtualization |
|
#Software Versions VM |
Software Measures |
Virtualization |
Measures Hidden for Hardware Report Type
The following table lists the measures that are hidden in the tables for the Hardware report type and will be enabled upon request:
|
Measure Name |
Table Name |
Sub Folder |
|
#Devices End of Sale in next 1 year |
Device Measures |
Date Measures |
|
#Devices End of Sale in next 180 days |
Device Measures |
Date Measures |
|
#Devices End of Sale in next 2 years |
Device Measures |
Date Measures |
|
#Devices End of Sale in next 3 years |
Device Measures |
Date Measures |
|
#Devices End of Sale in next 365 days |
Device Measures |
Date Measures |
|
#Devices End of Sale in next 90 days |
Device Measures |
Date Measures |
|
#Devices Obsolete Critical |
Device Measures |
Date Measures |
|
#Devices Obsolete High |
Device Measures |
Date Measures |
|
#Devices Obsolete in next 1 year |
Device Measures |
Date Measures |
|
#Devices Obsolete in next 180 days |
Device Measures |
Date Measures |
|
#Devices Obsolete in next 2 years |
Device Measures |
Date Measures |
|
#Devices Obsolete in next 3 years |
Device Measures |
Date Measures |
|
#Devices Obsolete in next 365 days |
Device Measures |
Date Measures |
|
#Devices Obsolete in next 90 days |
Device Measures |
Date Measures |
|
#Devices Obsolete in past |
Device Measures |
Date Measures |
|
#Devices Obsolete Low |
Device Measures |
Date Measures |
|
#Devices Obsolete Medium |
Device Measures |
Date Measures |
|
#Devices Obsolete Unknown |
Device Measures |
Date Measures |
|
#Hardware Manufacturers End of Sale Over Time |
Device Measures |
Date Measures |
|
#Hardware Manufacturers Obsolete Over Time |
Device Measures |
Date Measures |
|
#Hardware Models Obsolete in next 180 days |
Device Measures |
Date Measures |
|
#Hardware Models Obsolete in next 365 days |
Device Measures |
Date Measures |
|
#Hardware Models Obsolete in next 90 days |
Device Measures |
Date Measures |
|
#Hardware Models Obsolete in past |
Device Measures |
Date Measures |
|
#Business Services |
Device Measures |
None |
|
#Business Units |
Device Measures |
None |
|
#Cloud Provider |
Device Measures |
None |
|
#Cost Centers |
Device Measures |
None |
|
#Resource Name |
Device Measures |
None |
|
#Resource Region |
Device Measures |
None |
|
#Resource Type |
Device Measures |
None |
|
#Total Cloud Devices |
Device Measures |
None |
|
Days Left End of Sale |
Device Measures |
None |
|
Days Left Obsolete |
Device Measures |
None |
|
#Devices Obsolete Host |
Device Measures |
None |
|
Installs EOL % |
Software Measures |
None |
|
Installs GA % |
Software Measures |
None |
|
Installs Missing Version Information % |
Software Measures |
None |
|
Installs Obsolete % |
Software Measures |
None |
|
Installs Open Source Support % |
Software Measures |
None |
|
Installs Unpublished Lifecycle % |
Software Measures |
None |
Measures Available for Software Report Type
The following table lists the measures that are available in the tables for the Software report type:
|
Measure Name |
Table Name |
Sub Folder |
|
#Devices |
Device Measures |
None |
|
#Hardware Manufacturers |
Device Measures |
None |
|
#Hardware Models |
Device Measures |
None |
|
#Hardware Products |
Device Measures |
None |
|
Model to Product Ratio |
Device Measures |
None |
|
Past Installs EOL % |
Device Measures |
None |
|
#Installs EOL Over Time |
Software Measures |
Date Measures |
|
#Installs Obsolete Over Time |
Software Measures |
Date Measures |
|
#Software Products EOL Over Time |
Software Measures |
Date Measures |
|
#Software Products Obsolete Over Time |
Software Measures |
Date Measures |
|
#Software Releases Obsolete Over Time |
Software Measures |
Date Measures |
|
#Software Versions EOL Over Time |
Software Measures |
Date Measures |
|
#Software Versions Obsolete Over Time |
Software Measures |
Date Measures |
|
#File Evidence |
Software Measures |
Software Evidence |
|
#Installer Evidence |
Software Measures |
Software Evidence |
|
Total EOL LatestDate |
Software Measures |
Time Series |
|
Total Installs LatestDate |
Software Measures |
Time Series |
|
Total OBS LatestDate |
Software Measures |
Time Series |
|
#Installs |
Software Measures |
None |
|
#Installs EOL |
Software Measures |
None |
|
#Installs GA |
Software Measures |
None |
|
#Installs Missing Version Information |
Software Measures |
None |
|
#Installs Obsolete |
Software Measures |
None |
|
#Installs Open Source Support |
Software Measures |
None |
|
#Installs Unpublished Lifecycle |
Software Measures |
None |
|
Installs EOL % |
Software Measures |
None |
|
Installs GA % |
Software Measures |
None |
|
Installs Missing Version Information % |
Software Measures |
None |
|
Installs Obsolete % |
Software Measures |
None |
|
Installs Open Source Support % |
Software Measures |
None |
|
Installs Unpublished Lifecycle % |
Software Measures |
None |
|
#Software Editions |
Software Measures |
None |
|
#Software Manufacturers |
Software Measures |
None |
|
#Software Products |
Software Measures |
None |
|
#Software Releases |
Software Measures |
None |
|
#Software Releases EOL |
Software Measures |
None |
|
#Software Releases Obsolete |
Software Measures |
None |
|
#Software Versions |
Software Measures |
None |
|
#Software Versions Obsolete |
Software Measures |
None |
|
Installs Less Than Selected Value |
Software Measures |
None |
|
Software Version to Product Ratio |
Software Measures |
None |
Measures Hidden for Software Report Type
The following table lists the measures that are hidden in the tables for the Software report type and will be enabled upon request:
|
Measure Name |
Table Name |
Sub Folder |
|
#Install Obsolete in next 90 days |
Software Measures |
Date Measures |
|
#Installs EOL Critical |
Software Measures |
Date Measures |
|
#Installs EOL High |
Software Measures |
Date Measures |
|
#Installs EOL in next 1 year |
Software Measures |
Date Measures |
|
#Installs EOL in next 180 days |
Software Measures |
Date Measures |
|
#Installs EOL in next 2 years |
Software Measures |
Date Measures |
|
#Installs EOL in next 3 years |
Software Measures |
Date Measures |
|
#Installs EOL in next 90 days |
Software Measures |
Date Measures |
|
#Installs EOL in past |
Software Measures |
Date Measures |
|
#Installs EOL Low |
Software Measures |
Date Measures |
|
#Installs EOL Medium |
Software Measures |
Date Measures |
|
#Installs EOL Unknown |
Software Measures |
Date Measures |
|
#Installs Obsolete in next 1 year |
Software Measures |
Date Measures |
|
#Installs Obsolete in next 180 days |
Software Measures |
Date Measures |
|
#Installs Obsolete in next 2 years |
Software Measures |
Date Measures |
|
#Installs Obsolete in next 3 years |
Software Measures |
Date Measures |
|
#Software Manufacturers EOL Over Time |
Software Measures |
Date Measures |
|
#Software Manufacturers Obsolete Time |
Software Measures |
Date Measures |
|
#Software Versions EOL in next 180 days |
Software Measures |
Date Measures |
|
#Software Versions EOL in next 365 days |
Software Measures |
Date Measures |
|
#Software Versions EOL in next 90 days |
Software Measures |
Date Measures |
|
#Software Versions EOL in past |
Software Measures |
Date Measures |
|
#Software Versions Obsolete in next 180 days |
Software Measures |
Date Measures |
|
#Software Versions Obsolete in next 365 days |
Software Measures |
Date Measures |
|
#Software Versions Obsolete in next 90 days |
Software Measures |
Date Measures |
|
#Software Releases GA |
Software Measures |
None |
|
#Software Releases Missing Version |
Software Measures |
None |
|
#Software Releases Open Source Support |
Software Measures |
None |
|
#Software Releases Unpublished |
Software Measures |
None |
|
#Software Versions GA |
Software Measures |
None |
|
Days Left EOL |
Software Measures |
None |
|
Days Left Obsolete |
Software Measures |
None |
Measures Available for Vulnerabilities Report Type
The following table lists the measures that are available in the tables for the Vulnerabilities report type:
|
Measure Name |
Table Name |
Sub Folder |
|
Business Service with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Business Unit with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Cost Center with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
CVE with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Devices with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Domain with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Installs EOL Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Installs GA Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Installs Missing Version Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Installs Obsolete Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Installs Open Source Support Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Installs Unpublished Lifecycle Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Installs with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Location with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Recommended Softwares with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Recommended Versions with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Releases with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
SAID |
Vulnerability Measures |
Secunia Advisory |
|
Total Vulnerabilities with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Versions with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
Zero Day Vulnerabilities with Secunia Advisory |
Vulnerability Measures |
Secunia Advisory |
|
CVEs LatestDate |
Vulnerability Measures |
Time Series |
|
Total Vulnerabilities LatestDate |
Vulnerability Measures |
Time Series |
|
Business Service with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Business Unit with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Cost Center with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
CVE with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Devices with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Domain with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Installs EOL Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Installs GA Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Installs Missing Version Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Installs Obsolete Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Installs Open Source Support Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Installs Unpublished Lifecycle Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Installs with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Location with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Malware with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Software Manufacturer with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Software Product with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Software Release with Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Total Vulnerabilities |
Vulnerability Measures |
Vulnerability |
|
Versions with Vulnerabilities |
Vulnerability Measures |
Vulnerability |