cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Community Support Team
Community Support Team

Re: DAX Count number of unique values in one column only if frequency is over a certain number

Hi @frankkinsey,

 

Sorry for slow response.


According to your description, you want to check the distinct call count of employees whose count number are large than limit, right?

 

I have a idea to deal with this requirement:

 

1. Use current employee id to filter records.
2. Calculate the distinct count which the column which choose from above table.
3. Use if function to deal with the result.

 

Measure: (located at employee table)

Current Count=
var currEmployeeID= max(Employee[EmployeeID])
var temp=FILTER(RecordTable, RecordTable[EmployeeID]=currEmployeeID)
var distinctCount= COUNTAX(DISTINCT(SELECTCOLUMNS(temp,[Call])),[Call])
Return
if(distinctCount>[limitNumber],distinctCount,false())

 

If above formula still not help, can you share me a pbix file? I will check it.


Regards,

Xiaoxin sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
frankkinsey Frequent Visitor
Frequent Visitor

Re: DAX Count number of unique values in one column only if frequency is over a certain number

Thanks for the rsponse, you have been a huge help and definitely shown me some things about DAX I was unaware of!

 

I eventually got aroud the issues by using a calculated column which gave a distinct count if the employee ID which then used against the limitnumber. This way I could easily filter those over 3 responses as required.

 

Seems there are lots of ways to di these things? 

 

I'll also test this suggestion as it may prove useful.

 

Thank again,

 

Frank