Forum Discussion

jcarville's avatar
jcarville
Skilled Sharer
8 years ago
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'...
Need Help
Show and Tell
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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's avatar
Ashish_Mathur
Super User
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ashish_Mathur Great solution that worked perfectly for me. Thank you for the solution!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You are welcome.