Forum Discussion

tomranken's avatar
tomranken
Frequent Visitor
6 years ago

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 Analysis'[Customer Reported.Main CRM Account Name]))

 

How do i total this correctly?

 

 
 
 
 
Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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.⚡

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      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's avatar
        tomranken
        Frequent Visitor
        6 years ago

        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