topic Re: Percentage does not equal numerator / denominator in Developer

Percentage does not equal numerator / denominator

Anonymous — Tue, 21 Apr 2020 20:47:01 GMT

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:

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!

Re: Percentage does not equal numerator / denominator

nandukrishnavs — Wed, 22 Apr 2020 06:02:36 GMT

@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 🙂

Re: Percentage does not equal numerator / denominator

Anonymous — Wed, 22 Apr 2020 12:24:39 GMT

Great idea! However, they are both filtered only by the date.

Re: Percentage does not equal numerator / denominator

nandukrishnavs — Wed, 22 Apr 2020 12:35:20 GMT

@Anonymous - can you add both measures into the table visual and share the snapshot, please.

Re: Percentage does not equal numerator / denominator

Anonymous — Wed, 22 Apr 2020 12:50:09 GMT

I put those two items in a table and got what I would expect. It appears to be an issue with the card object that shows the 43%.

Re: Percentage does not equal numerator / denominator

nandukrishnavs — Wed, 22 Apr 2020 13:11:42 GMT

@Anonymous change the topN filter and manually select the filter value.

Re: Percentage does not equal numerator / denominator

Anonymous — Wed, 22 Apr 2020 13:40:32 GMT

I went to change the Timeseries_DT filter to basic filtering (which defaulted to the earliest date). I changed to the last date, and it didn't change. That's strange. I poked around and the issue is that most tables have a "Timeseries_DT" field that is the date of every row. Somehow, the % card was pulling from another table's "Timeseries_DT" column. I made it the correct one, and it works!

Thank you for helping me back up and work this issue out!