Forum Discussion

Vanessa250919's avatar
Vanessa250919
Icon for Helper V rankHelper V
4 years ago
Solved

Dax formula summarize?

Hello,   I created one formula dax: Count Distinct Agent total (VLT>0) = CALCULATE( DISTINCTCOUNT(MASTERTABLE[FULL_EMPLID]),MASTERTABLE[WLT_PO]>0,DIM_EMPLOYEE[HR_STATUS] = "ACTIVE")   But I hav...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Vanessa250919 ,

 

You could use ALLEXCEPT() function.

https://docs.microsoft.com/en-us/dax/allexcept-function-dax 

Count Distinct Agent total (VLT>0) = CALCULATE( DISTINCTCOUNT(MASTERTABLE[FULL_EMPLID]),FILTER(ALLEXCEPT(MASTERTABLE,[agent] ),MASTERTABLE[WLT_PO]>0,DIM_EMPLOYEE[HR_STATUS] = "ACTIVE"))

 

Best Regards,

Jay