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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Vanessa250919 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Try like

 

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