Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
nleuck_101
Resolver III
Resolver III

Total Distinct Count filtered by the count of a particular termination reason

Hello All,

 

I'm having some trouble with creating a DAX measure that calculates a distinct count of associates that have used a specific termination reason more than once. Anyone have any ideas how I would do this? I would greatly appreciate some help!

Thanks,

2 ACCEPTED SOLUTIONS
v-jingzhang
Community Support
Community Support

Hi @nleuck_101 

 

Assume your data is similar to the following table, you can try this measure.

Measure = 
var _tbl = SUMMARIZE('Table','Table'[ID],"count of reason b",COUNTROWS(FILTER('Table','Table'[Reason]="b")))
return
COUNTROWS(FILTER(_tbl,[count of reason b]>1))

vjingzhang_0-1665121797865.pngvjingzhang_1-1665121828828.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

nleuck_101
Resolver III
Resolver III

@v-jingzhang 

Your measure does work but if I need to selected a month to filter by, the value goes Blank. I decided to create what I needed in SQL and that worked for me. Thanks for your reply!

View solution in original post

2 REPLIES 2
nleuck_101
Resolver III
Resolver III

@v-jingzhang 

Your measure does work but if I need to selected a month to filter by, the value goes Blank. I decided to create what I needed in SQL and that worked for me. Thanks for your reply!

v-jingzhang
Community Support
Community Support

Hi @nleuck_101 

 

Assume your data is similar to the following table, you can try this measure.

Measure = 
var _tbl = SUMMARIZE('Table','Table'[ID],"count of reason b",COUNTROWS(FILTER('Table','Table'[Reason]="b")))
return
COUNTROWS(FILTER(_tbl,[count of reason b]>1))

vjingzhang_0-1665121797865.pngvjingzhang_1-1665121828828.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.