Instances of deviation from target values

[madeleineadams]

Hi all, trying to find a way to show how many times the value of a column in a data set deviates from an acceptable range - was assuming this should be a "New Measure" but wasn't sure? For example, if there is a column of data showing daily sales, how would you show the number of times where the sales for a day were lower than the target? I'm new to Power BI and would really appreciate the help!

[v-lid-msft]

Hi @madeleineadams ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @madeleineadams ,

We can try to create two measure to meet your requirement (assuming the range is 60-90 and target is 60)

deviates from range = CALCULATE(COUNT('Table'[Value]),'Table'[Value]>90 || 'Table'[Value]<60)

day lower than the target = CALCULATE(DISTINCTCOUNT('Table'[Date]),FILTER(DISTINCT('Table'[Date]),CALCULATE(SUM('Table'[Value]))<60))

If it doesn't meet your requirement, Could you please show the exact expected result based on the tables that we have shared? If you want to dynamic the range and target, we can create a What-If paramater to replace the 60 and 90, please refer to following document: https://docs.microsoft.com/en-us/power-bi/desktop-what-if

By the way, PBIX file as attached.

Best regards,

[az38]

Hi @madeleineadams 

welcome to the Community

please, first, read this useful guide https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

and my advice is to re-create this topic in Desktop section https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer