Measures
There are over 500 Measures available to assist with the development of dashboards. These Measures have been grouped into the following categories:
• Allocated By Depth Range
• Avg/Counts/Sum/Percentages
• Custom
• Date Calculations
• Financial
• KPIs
• Penetration/Depth/Distance
• Unit/Conversion
These categories should help you find the measures you need more quickly. Please let us know if you would like a copy of all the DAX measures we use in the data model by contacting our support team.
Calculation Groups
Calculation groups are used in Power BI to help reduce the number of Measures. Different calculations can be applied to existing Measures. Krux currently uses them for the following:
• Time intelligence
• Currency conversion
• Averages
Use 'CalcGroup_TimeIntelligence' and 'CalcGroup_Average' in combination with the measures listed in 'CalcGroup_Measures'. For currency conversion, use 'CalcGroup_MultiCurrency' to display charges in any currency (see example below):
Multi-Currency
Krux reports and dashboards can be viewed in multiple currencies. The calculated column ‘ChargesUSD’ within some of the Fact tables has been added for converting the ‘Charges’ column to a base currency of USD. This allows financial measures to be created that allow end-users to select the currency they want to see their reports in. Please note that the currency rates used change periodically to reflect the most current rates.
To see financial values in multiple currencies on your reports, follow these steps:
- Add a slicer to your report
- With the slicer selected, add the field ‘CurrencyCode’ from DIM_Currency
- With the slicer selected, add ‘CurrencyCode’ to the filter section ‘Filters on this visual’ and de-select ‘Unknown’
- From the calculation group ‘CalcGroup_MultiCurrency’, add ‘CurrencySymbol’ to the filter section ‘Filters on all pages’ and select ‘ApplyCurrencyFormat’ from the dropdown
