Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@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)])))
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
Hi @Anonymous
If the problem is still there, could you share any sample data?
Best Regards
Maggie
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |