Forum Discussion

bhartsell's avatar
bhartsell
Frequent Visitor
10 years ago
Solved

Getting distinct values for multiple columns

Hi    I tried looking through previous threads, but I'm not sure what exactly what I'm looking for would be called.    I have a table with several columns, but I'm concerned with two of them: Bun...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    bhartsell

     

    1. Insert a Table Visual and put in Values: BundleID and UserEmail.

    2. In UserEmail select Count(Distinct).

     

     

  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    bhartsell

     

    If you want a visual by date, use the same solution provided by Vvelarde and just change the visual from Table to Line and clustered column chart as below.

     

     

    Best Regards,

    Herbert

bhartsell's avatar
bhartsell
Frequent Visitor
9 years ago

Thanks for the response!

 

I'm sorry if I wasn't clear, but I'm trying to find a measure (or series of measures) that allows me to put this in a visual by date. I need it to be non-repeating by BundleID for every UserEmail. So if the data set I'm using is the below, then the count for BundleID 1 is three (three different emails), the count for 2 is 1 (one different email), the count for three is 2 (two different emails), and the total count is six.

 

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

bhartsell

 

If you want a visual by date, use the same solution provided by Vvelarde and just change the visual from Table to Line and clustered column chart as below.

 

 

Best Regards,

Herbert