Forum Discussion
ninjoan
3 years agoFrequent Visitor
Power Bi mathematical measure.
I am quite new to Power Bi I have been learning by watching videos on Youtube, but I have reached a stage where I still don't understand how I can make a mathematical formula.
I have this so far thanks to the help of another user.
SLA1 = SUMX(Cola,DIVIDE([TotalCallSansweredThreshold], ([cTotalLlamadasContestadas] + Cola[cTotalLlamadasAbandonadas])) * 100)
But for some reason, the result of this is 1200.
If I do the calculation in excel it gives me 7.18%.
=(12/(136+31))*100
Values
[TotalCallSansweredThreshold] = 12
[cTotalLlamadasContestadas] = 136
[cTotalLlamadasAbandonadas] = 31
Hi,
Shouldn't it just be this measure. Just format it as %
SLA1 = DIVIDE([TotalCallSansweredThreshold], ([cTotalLlamadasContestadas] + [cTotalLlamadasAbandonadas])My assumption is that all 3 inputs in that formula are explicit measures.
3 Replies
- Ashish_Mathur
Super User
Hi,
Shouldn't it just be this measure. Just format it as %
SLA1 = DIVIDE([TotalCallSansweredThreshold], ([cTotalLlamadasContestadas] + [cTotalLlamadasAbandonadas])My assumption is that all 3 inputs in that formula are explicit measures.
- ninjoanFrequent Visitor
WOW! THANKS!
- Ashish_Mathur
Super User
You are welcome.