Forum Discussion
Row Value incorrect when including Dimension
I have a Budget table with the following fields:
- BudgetMonth
- Country
- Customer
- BudgetSales
I then have the following measure
[Budget Amt] := sum(Budget[BudgetSales])
When showing the [Budget Amt] per Month, my values are correct. If I however add the dimension of Country or Customer, the values are then incorrect. Curiously, the grand total values remain correct.
I've done some reading on the semi-additive measures and issues regarding the calculations for Grand Totals - I'm not entirely sure if my scenario relates to either of these, but noen of the material I've come across has clarified the issue for me.
Hi wi11iamr,
By my tests with your scenario, it seems that the measure works fine.
If you still need help, please share a dummy pbix file which can reproduce the scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
2 Replies
Hi wi11iamr,
By my tests with your scenario, it seems that the measure works fine.
If you still need help, please share a dummy pbix file which can reproduce the scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Hi wi11iamr ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Best Regards,
Cherry