Filter KPI by value of measure

[danielakunz]

Hello,

I have a measure in my Power BI Report that calculates a Total score based on two other measures.

Score cases = DISTINCTCOUNT('Cases - Overview'[Case ID])*2

Score missions = DISTINCTCOUNT(Missions[Mission ID])*10

Total score = [Score missions]+[Score cases]

This measure is evaluated by machine ID, meaning I get a score per machine that shows how many cases and missions a machine has based on the score.

I want to set an alert in my Power BI Dashboard, if a machine reaches a score of 50 points.

I thought about using a KPI visual that counts the number of machine ID, while the filter "Total score > 50" is applied. Then I set the alert on the KPI visual reaching a value > 0.

However, I can't set a filter with Total score for the KPI visual. What am I doing wrong?

Is there another way to get the alert?

Thank you!

Daniela

[v-shex-msft · Accepted solution]

Hi @danielakunz,

So you want to set a filter based naggrated result instead of underline records values, right?

If this is a case, you can consider writing a measure formula with variables that aggregate total level records and compare with the current result and use it on the visual level filter to filter records.

Applying a measure filter in Power BI 

Measure Totals, The Final Word 

If the above not help, please share some dummy data and expected results to help us clarify your scenario and test coding formula.

How to Get Your Question Answered Quickly 
Regards,
Xiaoxin Sheng

[Pragati11]

Hi @danielakunz ,

You can create data alerts in Power BI Service based on your metric. Check the folllowing link:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Thanks,

Pragati

[danielakunz]

Unfortunately, that doesn't fix my problem. I know how to set an alert. My problem is I can't build a tile that displays the right data.