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

Distinct Count based on Sum of other Column and Group

I have the table below and I'm trying to construct a DAX formula to do the following calculation in PowerBI, but haven't succeeded.

 

Column A,B,C is the actual data, In excel I created a pivot table in F2 column and then created an other table to get the UserID count using FREQUENCY function

 

DAXhelpVishwa.PNG

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors