Forum Discussion
Power BI Calculated Measure - Returning the figures correctly in the matrix.But the total is incorr
srigag900 Sub-Total was not the issue, grand total is showing incorrect.
After exporting data i can see Grand Total is 227200, not 13975000.
Revenue at Risk Corrected = SUMX( SUMMARIZECOLUMNS( 'Stock Type'[Name], 'Size Table'[SIZE] ), VAR CurrentStock = CALCULATE([Stock in Hand]) VAR CurrentUnitPrice = CALCULATE(SUM('Price Table'[Unit Price])) RETURN IF( CurrentStock < 0, CurrentUnitPrice * ABS(CurrentStock), 0 ) )Test this measure and let me know the progress.
Super UserThanks for the file, i found something incorrect in your file, you applied some visual level fileter and some page level filter.
I just move your table visual level filter to page level filter and your existing measure is now working perfectly fine. Verify and let me know.
https://drive.google.com/file/d/1y9t6v7zedoN5cLLwTPbez9TjtAy86PNK/view?usp=drive_link
Hi Royel ,
thank you for the response .
But if you take the total out from the revenue at risk column, the total value is 2 Mn. not 13.9mn. you can export this in to a csv and can check..
any idea on why im getting this?
- Royel
srigag900 Sub-Total was not the issue, grand total is showing incorrect.
After exporting data i can see Grand Total is 227200, not 13975000.
Revenue at Risk Corrected = SUMX( SUMMARIZECOLUMNS( 'Stock Type'[Name], 'Size Table'[SIZE] ), VAR CurrentStock = CALCULATE([Stock in Hand]) VAR CurrentUnitPrice = CALCULATE(SUM('Price Table'[Unit Price])) RETURN IF( CurrentStock < 0, CurrentUnitPrice * ABS(CurrentStock), 0 ) )Test this measure and let me know the progress.