Power BI DAX

[Anonymous]

I am trying to calculate a complaince %. The compliance is the count of number under 270. A simple calucation would be:

(count of durantion times under 270) / (count of duration times)

This is the DAX I am trying to use in a quick masure but its not working. Any suggestions

Measure 1 = (CALCULATE(COUNT('2020 Turn Around Times'[Turnaround Time (Minutes)]), '2020 Turn Around Times'[Turnaround Time (Minutes)]<=270))/(COUNT('2020 Turn Around Times'[Turnaround Time (Minutes)]))

Thanks!

Robin

[amitchandak]

@Anonymous , for the filter you need a row context, I assumed that as call ID (Replace with the correct column)

Try lik

Measure 1 = (CALCULATE(COUNTX(Filter(Summarize('2020 Turn Around Times','2020 Turn Around Times'[Call ID],"_1",[Turnaround Time (Minutes)]), [_1]<=270),[_1])/(COUNT('2020 Turn Around Times'[Turnaround Time (Minutes)])))

[Anonymous]

That didn't work.  The correct calculation (I know because I tested it in Excel) is 55.56%. Below is a screen shot of the data I'm working with. I need to know the % of times that the minutes are less than or equal to 270.

Thank you for your help

[v-juanli-msft]

Hi @Anonymous 

If the problem is still there, could you share any sample data?

Best Regards

Maggie

[mahoneypat · Accepted solution]

I think I ended up writing the same measure as you did, but it got the expected result.

Pct on Time =
CALCULATE (
COUNT ( '2020 Turnaround Times'[Turnaround Time (Minutes)] ),
'2020 Turnaround Times'[Turnaround Time (Minutes)] <= 270
)
/ COUNT ( '2020 Turnaround Times'[Turnaround Time (Minutes)] )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat