Forum Discussion
Solved
Incorrect Measure Total
Hi, I am getting the incorrect total for my measure '% Turnover Value'. The total is showing 135,656, but I expect a figure of 69,089. I am presuming the Accounts with no 'Average of % Turnover'...
Hi,
The SUMX() portion of the formula should be something like this
=SUMX(SUMMARIZE(VALUES(Rebates[Account/Group]),[Account/Group],"ABCD",SUM(Sales value final)*AVERAGE(Rebates[% turnover])),[ABCD])
Include the curency symbol in the underlines portion.
If this formula does not help, then share the link from where i can download your PBI file.
Ashish_Mathur Great solution that worked perfectly for me. Thank you for the solution!
You are welcome.