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
7 years ago

I'm having a similar struggle  where within my datagrid individuals rows are calculating but the total line is wrong.

 

Stuck thoughts?

 

Here is my Dax expression:

 

MTD_PY_Variance_Matrix =
 (
    CALCULATE (
        KPI_Finance_Matrix[MTD_Actuals_Matrix] - KPI_Finance_Matrix[MTD_PY_Actuals],
        KPI_Finance_Matrix[Group] = "Revenue"
    )
)
    + (
        CALCULATE (
            KPI_Finance_Matrix[MTD_Actuals_Matrix] - KPI_Finance_Matrix[MTD_PY_Actuals],
            KPI_Finance_Matrix[Group] = "Gross Margin"
        )
    )
    + (
        CALCULATE (
            KPI_Finance_Matrix[MTD_PY_Actuals] - KPI_Finance_Matrix[MTD_Actuals_Matrix],
            KPI_Finance_Matrix[Group] = "Operating Expenses"
        )
    )