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.
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.