Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Compare measures to thresholds

Is there a way to create a decent size number of measures (10-20) and then compare them to threshholds?   Ideally I would be able to have a table that looks like:   kpi target min max me...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Data:

 

KPI:

 

You may create two calculated column as below.

Min = 
SWITCH(
    'KPI'[KPI],
    "measure1",MIN(Data[Value1]),
    "measure2",MIN(Data[Value2]),
    "measure3",MIN(Data[Value3]),
    BLANK()
)

Max = 
SWITCH(
    'KPI'[KPI],
    "measure1",MAX(Data[Value1]),
    "measure2",MAX(Data[Value2]),
    "measure3",MAX(Data[Value3]),
    BLANK()
)

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.