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.
Hi All
I tried searching the forums for previous posts but all existing examples are so specific that none of the solutions were able to help me.
I am sure this is going to be a simple fix but I am having some beginers issues unfortunately.
---
Basically, I work out our SLA for our phone team but when the team gets 0 calls the SLA is at 100%. This confuses some readers of my report and so I want to build a DAX measure that would say:
IF(Phones[Offered]=>0, "N/A" ELSE (perform equation to work out SLA%) SUMX(Phones,Phones[SL]*Phones[Offered])/sum(Phones[Offered])
Any help on this would be greatly appreciated.
Many thanks in advance.
Kind regards
Paul
Solved! Go to Solution.
I assume the SLA should be calculated for Phones Offered >0, if it is as in your example it's easy to correct
SLA% = IF ( SUM ( Phones[Offered] ) > 0, DIVIDE ( SUMX ( Phones, Phones[SL] * Phones[Offered] ), SUM ( Phones[Offered] ) ), "N/A" )
if this doesn't work can you paste here few rows of sample data from Phones table? should be anonymised
I assume the SLA should be calculated for Phones Offered >0, if it is as in your example it's easy to correct
SLA% = IF ( SUM ( Phones[Offered] ) > 0, DIVIDE ( SUMX ( Phones, Phones[SL] * Phones[Offered] ), SUM ( Phones[Offered] ) ), "N/A" )
if this doesn't work can you paste here few rows of sample data from Phones table? should be anonymised
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |