Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Dax expression with filters

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.

1 REPLY 1
amitchandak
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors