Dax expression with filters

Anonymous — Sat, 10 Apr 2021 12:43:49 GMT

Hi All,

I need to design the distinctcount based on the below filters,

count distinct PersonIDHash from the D_Person table.

filters that we need to use,

where
Parameter!Date_from between D_Person.RowStartDate and D_Person.RowEndDate and
D_Person.MunicipalityKEY in (D_Municipality selected) and (D_Person.BirthYear - Parameter!Date_from) = D_AgeGroup.Age (selected AgeGroup) and (d.person.died=0 or d.person.diedate > Date to

Could you please suggest how that I need to proceed.

Thanks in advance.

Re: Dax expression with filters

amitchandak — Mon, 12 Apr 2021 04:52:40 GMT

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

topic Dax expression with filters in DAX Commands and Tips

Dax expression with filters

Re: Dax expression with filters