Forum Discussion
tomranken
6 years agoFrequent Visitor
Measure total in a Matrix
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 Anal...
parry2k
6 years agoSuper User
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
6 years agoFrequent Visitor
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