Forum Discussion
Power BI Calculated Measure - Returning the figures correctly in the matrix.But the total is incorr
- 1 year ago
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.
There is simply a visual filter issue, now it is fixed
in the matrix you have a filter on locations that was not replicated to the card, therefore the difference
Here is the modified file
https://drive.google.com/drive/folders/1wV1kqcT8Pj8iEsfZRVa212ilu0MmYvwC?usp=sharing
If this helped, please consider giving kudos and mark as a solution
mein replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hello FBergamaschi
Thank you for sharing your thoughts here. Yes i was missing a filter here. 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?
- FBergamaschi1 year ago
Super User
I just noticed that
I shall have to check it but please meanwhile can we close this issue and you create another one? This is another subject indeed, you can create it in the DAX section
Best
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI