Forum Discussion
Percentage does not equal numerator / denominator
I need some help with a %. There are three objects here. One % on a card, one showing the numerator & denominator, and a text box with a target. 488 / 1185 = 41.2%....not 43%. I've validated they are both coming from the same columns, as seen below. The value of the variables is the same. One is showing the numerator & denominator, and one is doing the calculation.
The % is coming from this measure:
The Num/Denom text is coming from the measure:
Measure2 =
var SumIsCompPct = SUM(WorkItem_rollup[IsCompliant])
var SumIsCompTotPct = SUM(WorkItem_rollup[Total])
return DIVIDE(SumIsCompPct,SumIsCompTotPct,0)
The Num/Denom text is coming from the measure:
2_NumDenom =
var SumIsComp = SUM(WorkItem_rollup[IsCompliant])
var SumIsCompTot = SUM(WorkItem_rollup[Total])
return "(" & SumIsComp & " / " & SumIsCompTot & ")"
Does anyone know why I get an incorrect 43%? Oh, data types are:
IsCompliant: Whole Number
Total: Whole Number
Measure2: Percentage of precision 2
2_NumDenom : Text
Thanks!
Anonymous change the topN filter and manually select the filter value.
6 Replies
Anonymous
Check if there is any visual level filter applied or not?
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Anonymous - can you add both measures into the table visual and share the snapshot, please.