Power Bi mathematical measure.

[ninjoan]

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

[Ashish_Mathur · Accepted solution]

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.

[ninjoan]

WOW! THANKS!

[Ashish_Mathur]

You are welcome.