Measure total in a Matrix

[tomranken]

Hello,

I cant get the total of my measure in a matrix correct.  

the measure in a matrix is this and returns a count of 1 when there is a value.

Measure = COUNTROWS(VALUES('Sales Analysis'[Customer Reported.Main CRM Account Name]))

How do i total this correctly?

[tomranken]

it has now counted the field not the measure

[parry2k]

@tomranken not sure what you are trying to do, try this

Measure 2 =
SUMX ( VALUES ( Table[Customer] ), [Measure] )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[tomranken]

Sorry that didnt work either,

I would like the row total to be correct. So the row total for the first row should be 2, the seccond row, 1. 

but this value is a measure which i think is making the total wrong

[parry2k]

@tomranken measure should be

Measure = COUNTROWS( Table )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡