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.
Apologies if this is overly simple but I am new to DAX. I am trying to calculate an escalation percentage as defined as (# of Escalated 2s + # of Escalated 3s) / (# of Assigned). The data looks like:
Event Column
Assigned
Escalated 2
Assigned
Escalated 3
Assigned
Assigned
For the above data, the escalation percentage should be 50%.
Thanks for your help
Solved! Go to Solution.
HI @jeffatkins79 ,
You can try to use following measure to calculate percent of 'escalated' and 'assigned'.
Measure = DIVIDE ( COUNTROWS ( FILTER ( ALLSELECTED ( Table1 ), SEARCH ( "Escalated", [Event Column], 1, -1 ) > 0 ) ), COUNTROWS ( FILTER ( ALLSELECTED ( Table1 ), [Event Column] = "Assigned" ) ) )
Regards,
Xiaoxin Sheng
HI @jeffatkins79 ,
You can try to use following measure to calculate percent of 'escalated' and 'assigned'.
Measure = DIVIDE ( COUNTROWS ( FILTER ( ALLSELECTED ( Table1 ), SEARCH ( "Escalated", [Event Column], 1, -1 ) > 0 ) ), COUNTROWS ( FILTER ( ALLSELECTED ( Table1 ), [Event Column] = "Assigned" ) ) )
Regards,
Xiaoxin Sheng
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |