Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Partially wrong total in matrix

Hi,

 

I have recently discovered an error in my report. For some reason the total (bottom row) in my matrix does not display the correct sum of values.

 

The matrix is structured in 3 hierarchial levels (rows) and contains different columns. All but one column totals are correct. The last column, which comes from another data set which is linked to the base data inside the model, displays correct calues for all individual rows accross all hierarchies. However, the total is incorrect (31 + 80 + 43 + 17 != 189). The only difference between this columns data and the rest of the matrix is, that the values do only exist for hierarchies 1 & 2 but not for 3 (unlike the other columns). The measure for the data is a straight forward Calculate(SUM(...)).

 

Does anyone have an idea what might be causing this issue and how I will be able to solve this?

 

Screenshot of the problem will be added in separate post. Due to too much sensitive data, I can not share the pbix.

 

Thanks in advance!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Anonymous  ,

    Could you try using the formula below to create a new measure to see if it works?

    Measure =
IF (
    HASONEVALUE ( TableName[Produkt] ),
    [error total]
    SUMX ( ALLSELECTED ( TableName[Produkt] ), [error total] )
)

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.