Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Matrix values doesn't add up

Hello, I've a matrix with one column containing Name and one column with values Agile, Bold, Engaged, Not, Smart. The total of distinct count names is 159, but the number doesn't add. I hav...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from Kaviraj11 , please allow me to provide another insight: 

    Hi  Anonymous ,

    Are you referring to the incorrect total row calculation? You can consider using the IF() + HASONEVALUE() function to determine if it’s a total. If it is, you can perform calculations based on your requirements, such as average, sum, etc.

    Measure =
var _table=
SUMMARIZE('Table',[Name],"Value",[Count])
return
IF(
    HASONEVALUE('Table'[Name]),[Count],SUMX(_table,[Value]))

     

     

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from Kaviraj11 , please allow me to provide another insight: 

Hi  Anonymous ,

Are you referring to the incorrect total row calculation? You can consider using the IF() + HASONEVALUE() function to determine if it’s a total. If it is, you can perform calculations based on your requirements, such as average, sum, etc.

Measure =
var _table=
SUMMARIZE('Table',[Name],"Value",[Count])
return
IF(
    HASONEVALUE('Table'[Name]),[Count],SUMX(_table,[Value]))

 

 

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.