Forum Discussion

govi's avatar
govi
Helper II
7 years ago
Solved

Count unique values

Hi,   I created this table:   Rows: userName Values: Count of message Filter: specific message Filter: Score B   I want to count the unique userNames (14).   I need the number (14) i...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    The table to which I am referring is the table in the data model that contains the data you are putting into the matrix.

     

    I would suggest going through Microsoft's free guided learning for PowerBI if you are unfamiliar with the platform

dedelman_clng's avatar
dedelman_clng
Community Champion
7 years ago

The table to which I am referring is the table in the data model that contains the data you are putting into the matrix.

 

I would suggest going through Microsoft's free guided learning for PowerBI if you are unfamiliar with the platform

govi's avatar
govi
Helper II
7 years ago

Hi dedelman_clng,

 

I found a solution:

  • I copied the concerning table.
  • Filtered it
  • And used a COUNTROWS/DISTINCT combination to return the required result

Thanks! You led the way