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

govi's avatar
govi
Helper II
7 years ago

Thanks dedelman_cling

 

But I don't know how to do that.

 

Do I first have to create the table with a dax formula?

 

I made the table I showed earlier with the use of the matrix visualization, I dont think I can use DISTINCTCOUNT agaainst that, do I?

 

Thanks!

govi

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