Forum Discussion
nleuck
Post Patron
Post PatronPower BI totals not adding up correctly
Hello Everyone, 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 P...
nleuckPost Patron
Post Patron
I get that. But take a calculator and those numbers up they don't add up to the total. The visual is misleading.
m3tr01dContinued Contributor
Hi nleuck ,
I understand but I'm just saying that the result is as expected from the DAX you have.
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] )Hope this helps.
