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...
Need Help
Need Help DAX
  • Anonymous's avatar
    Anonymous
    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

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