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 have one issue, I need to calculate the nbrs of agent ACTIVE with WLT_PO >0 but WLT_PO By agent and not total WLT_PO, it's possible?
Need Help
Need Help DAX

2 Replies

  • 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") )