Forum Discussion

ninjoan's avatar
ninjoan
Frequent Visitor
3 years ago
Solved

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

  • 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.