topic Dax formula summarize? in DAX Commands and Tips

Dax formula summarize?

Vanessa250919 — Tue, 01 Feb 2022 14:08:52 GMT

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?

Re: Dax formula summarize?

amitchandak — Tue, 01 Feb 2022 15:17:43 GMT

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

Re: Dax formula summarize?

Anonymous — Mon, 14 Feb 2022 08:36:03 GMT

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