DAX Help - DISTINCTCOUNT

[Anonymous]

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 

[v-lili6-msft · Accepted solution]

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

[Ashish_Mathur]

Hi,

Show some data and also the expected result.