Forum Discussion

mdol678's avatar
mdol678
Regular Visitor
2 years ago
Solved

Matrix Row Subtotals Incorrect

Hi all, help please, the simple matrix visual that I created has incorrect totals for some columns only. This was created using the basic matrix visual tool. I have very little DAX knowledge.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mdol678 ,

     

    Exceptions to the total value in the matrix are generally the result of calculations in the measure formula added to the value(and not the result of dragging the original field into the value for automatic aggregation). You can refer to the location of the following screenshot to see the fields or measures used in the created matrix.

     

    Also I have made simple demos which I hope will help you understand.

     

    result_ = COUNTROWS('Table')
    assets = 
IF (
    HASONEVALUE ( 'Table'[Status] ),
    COUNTROWS ( 'Table' ),
    COUNTROWS ( FILTER ( 'Table', 'Table'[Other] <> "No pass" ) )
)

     

     

    Best Regards,
    Adamk Kong

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mdol678 ,

 

Exceptions to the total value in the matrix are generally the result of calculations in the measure formula added to the value(and not the result of dragging the original field into the value for automatic aggregation). You can refer to the location of the following screenshot to see the fields or measures used in the created matrix.

 

Also I have made simple demos which I hope will help you understand.

 

result_ = COUNTROWS('Table')
assets = 
IF (
    HASONEVALUE ( 'Table'[Status] ),
    COUNTROWS ( 'Table' ),
    COUNTROWS ( FILTER ( 'Table', 'Table'[Other] <> "No pass" ) )
)

 

 

Best Regards,
Adamk Kong

 

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