Forum Discussion
Solved
Power BI Incorrect Total in Pivot Table
Hey Power BI Wizard, I have met the total error in my power bi, and I scratched out my head still couldnt solve it. For context: I have a forecast and actual sales dataset for my power bi, and I ...
Hi TanHY
The most likely cuplrit is you conditional formula after RETURN. MAX ('Date'[Date]) is evaluated differently at each hierarchy level. Try in a new measure:
SUMX ( SUMMARIZECOLUMNS ( 'table'[Category], 'table'[Subcategory], "@Development", [Development ] ), [@Development] )Change category and subcategory to the actual row columns in your matrix.
Hi,
Thanks. its work!!
