Power BI totals not adding up correctly

Question

Hello Everyone,&nbsp;I'm having some trouble with Power BI totals in a table not adding up to the correct amount. I've tried it two different ways and got the same result. The total I'm getting from Power BI is 10,155 but when you add up the numbers it should be 11,211.&nbsp;&nbsp;The first total is a measure TOTALYTD(DISTINCTCOUNT(table[LedgerID]), datetable[date])The second total is just column LedgerID where I do a Count (Distinct) on the value and I filter on Year 2021.&nbsp;Any help would be greatly appreciated.&nbsp;Thanks!

aj1973 · Answer

Hi&nbsp;nleuck&nbsp;Is 11,211 the count totaling duplicate values?Is there a filter applied somewhere?You are not providing much details, can you share your file please?&nbsp;

nleuck · Answer

aj1973&nbsp;&nbsp;If you add those totals up in the screenshot they don't add up to 10,155. When I add those numbers together I get 11,211.

m3tr01d · Answer

nleuck&nbsp;It's exactly as&nbsp;aj1973&nbsp;is saying. LedgerId is present in multiple months and the distinct count is only counting once LedgerId. The grand total will always be smaller.

nleuck · Answer

m3tr01d&nbsp;&nbsp;I get that. But take a calculator and those numbers up they don't add up to the total. The visual is misleading.

m3tr01d · Answer

Hi&nbsp;nleuck&nbsp;,&nbsp;I understand but I'm just saying that the result is as expected from the DAX you have.&nbsp;Then, you can either remove the grand total from the table if you don't need it or change the logic of the DAX.If you want to change the grand total so the numbers are added up. You can do it like this :YTD_Measure = TOTALYTD(DISTINCTCOUNT(table[LedgerID]), datetable[date])

YTD_Visual = 
SUMX( 
    VALUES( Table[MonthNameShort] ),
    [YTD_Measure]
)&nbsp;Hope this helps.

Forum Discussion

Power BI totals not adding up correctly

8 Replies

Related content

Total % not showing correctly

Totals Not adding up correctly

Grand Total not adding correctly

Matrix Adding total from previous Group

Totals not adding up correctly