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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors