Power BI DAX: Benchmark Measures and Calculated Field Values for Visual Conditional Format
This video introduces an approach on using DAX formula to create the measures for change values based on selected context, such as the Blood pressure checking benchmarks in terms of different age groups and gender , and apply the measurs to calculate columns for fixed values, such as field values for each record for line visual conditional format. This video also mentiones one method on how to find and create HEX colour codes from power BI desktop file, and how to create mapping index column in two tables for their merges.
In the approach the DAX functions Lookupvalue, Selectedvalue, Switch and Fixed have been introduced and applied.
References :
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...
SELECTEDVALUE function - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...
SWITCH function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...
FIXED function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...
For more info of my BI & Analytics, please refer to the following website links:
My BI & Analytics Website:
https://sites.google.com/view/mikegua...
My blog website :
https://mikeyubianalytics.blogspot.com/
