cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhartsell Frequent Visitor
Frequent Visitor

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: BundleID (a number associated with a "bundle" of files) and UserEmail. I'm trying to find out a way to count how many distinct UserEmails have downloaded distinct BundleIDs--how would I do this?

 

Thank you for your time!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: Getting distinct values for multiple columns

@bhartsell

 

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

2. In UserEmail select Count(Distinct).

 

 

Datas.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




v-haibl-msft Super Contributor
Super Contributor

Re: Getting distinct values for multiple columns

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

 

Getting distinct values for multiple columns_1.jpg

 

Best Regards,

Herbert

5 REPLIES 5
ankitpatira Super Contributor
Super Contributor

Re: Getting distinct values for multiple columns

@bhartsell i think all you need to do is use a visual such as column chart and drop useremail field to the axis area and drop bundleID field to the values area and under Values for the bundleID field click on dropdown icon and choose distinct count.

 

Capture.PNG

v-haibl-msft Super Contributor
Super Contributor

Re: Getting distinct values for multiple columns

@bhartsell

 

Please try the solution provided by ankitpatira. In case that’s not what you expected, please post back with expected output.

 

Best Regards,

Herbert

bhartsell Frequent Visitor
Frequent Visitor

Re: Getting distinct values for multiple columns

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.

 

Emails.png

Vvelarde Super Contributor
Super Contributor

Re: Getting distinct values for multiple columns

@bhartsell

 

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

2. In UserEmail select Count(Distinct).

 

 

Datas.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




v-haibl-msft Super Contributor
Super Contributor

Re: Getting distinct values for multiple columns

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

 

Getting distinct values for multiple columns_1.jpg

 

Best Regards,

Herbert

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 102 members 1,565 guests
Please welcome our newest community members: