Forum Discussion
DAX Help - DISTINCTCOUNT
Hi All,
I'm a bit stuck on something. What i'm trying to do is get a distinct count of unique employees and then based on these unique employees, i want to get the total sales made by employees who are Full Time.
So for example, i have a empNo field, EmpStatus field (which contains full time, part time, and casual), and a sales field.
I can't seem to get my formula to work. I did DISTINCTCOUNT([empNo.] to get unique employee numbers but i can't seem to figure out how to then filter this to return total sales for employees who are full time.
Thanks all
hi, Anonymous
You could use "FILTER" in your dax formula.
For example:
Measure = CALCULATE( DISTINCTCOUNT([empNo.] , FILTER( 'Table', [EmpStatus] = "full time"))
If not your case, please share some sample data and expected output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
2 Replies
- Ashish_Mathur
Super User
Hi,
Show some data and also the expected result.
v-lili6-msftCommunity Support
hi, Anonymous
You could use "FILTER" in your dax formula.
For example:
Measure = CALCULATE( DISTINCTCOUNT([empNo.] , FILTER( 'Table', [EmpStatus] = "full time"))
If not your case, please share some sample data and expected output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
