Forum Discussion

GeorgWildmoser's avatar
GeorgWildmoser
Frequent Visitor
2 years ago
Solved

Dax Query Incorrect Total

Hi, my DAX query is producing the correct values by line but the incorrect value for the total.    I thought I could fix the total problem with sumx. But obviously I'm doing something wrong...
DaxQuery Total
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi GeorgWildmoser 

     

    There is a general method to solve the problem that the total does not equal the breakdown, you can refer to it.

     

    Create New Measure = 
SUMX(
    CROSSJOIN(
        VALUES('Table'[Row Field1]),
        VALUES('Table'[Row Field2]),
        VALUES('Table'[Row Field3]),
        ...
    ),
    [Old Measure]
)

     

    According to your screenshot, you should fill the first 6 columns into VALUES in order.

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

     

xifeng_L's avatar
xifeng_L
Super User
2 years ago

Hi GeorgWildmoser 

 

There is a general method to solve the problem that the total does not equal the breakdown, you can refer to it.

 

Create New Measure = 
SUMX(
    CROSSJOIN(
        VALUES('Table'[Row Field1]),
        VALUES('Table'[Row Field2]),
        VALUES('Table'[Row Field3]),
        ...
    ),
    [Old Measure]
)

 

According to your screenshot, you should fill the first 6 columns into VALUES in order.

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~