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:
(perform equation to work out SLA%)
Any help on this would be greatly appreciated.
Many thanks in advance.
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
SUM ( Phones[Offered] ) > 0,
SUMX ( Phones, Phones[SL] * Phones[Offered] ),
SUM ( Phones[Offered] )
if this doesn't work can you paste here few rows of sample data from Phones table? should be anonymised
Proud to be a Super User!
View solution in original post
Many thanks @Stachu that worked perfectly!!
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.