Forum Discussion
KeepCalm007
7 years agoHelper I
DAX Help - Calculation with Filters for KPI data
Hello Power BI community I have a table of KPI data for a list of services. Each service has different KPI light indicator ranges based on the group it is from. I was able to create a colu...
v-danhe-msft
7 years agoMicrosoft Employee
Hi KeepCalm007,
Based on my research, it seemed that you could use the "UNCHAIR" function to switch you data to different KPI symbol, you could refer to below link:
Regards,
Daniel He
KeepCalm007
7 years agoHelper I
Hi Daniel v-danhe-msft
Thanks for your suggestion. However, it is not the output symbol I am having difficulty with, it is the calculation (formula) to get the right one for each 'group'.
In the examples you provided, the measure is based the same conditions for the whole length of the column whether an upward arrow or downward arrow is showing.
This is not the case for my situation :(