Forum Discussion
JDeMaro22
3 years agoFrequent Visitor
PowerBi Column Totals Discrepancy Inquiry
Hi, I've tried to read multiple articles on this issue but I'm looking for a more direct answer. I'm trying to understand why my total values number showcases a different value when I manually su...
HotChilli
3 years agoCommunity Champion
What are you showing us here?
Is 98,109 the number you expect to see at the bottom of the ReferrredPatients Total column? In which case it looks like a standard 'measure totals' issue and could possibly be explained by the same patient being in more than one location name.
I would need to see the data model plus the exact definition of the measure used (also the measure on the right).
--
These things are obviously easier to track down with a smaller data sample where you can focus on the arithmetic to find the discrepancy.