cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Divya904 Member
Member

Filter on multiple measures

Hi Experts,

 

Please help me to solve this. I have a table report which has two text columns and 5 DAX measures.

Text Columns : Cutomer No. , Customer Name

Measures : Total, Age 1-20, Age 21-40, Age 41-60, Age 61-80

 

I have created a table report. In this report, i need to filter out all the rows where there is 0 for all the measures.

For example i want to filter out Customer BBB (row no. 2)  from my table.

 

Customer No.Customer NameTotal Age 1-20 Age 21-40Age 41-60Age 61-80
11AAA13692.50321.6307938.525432.35
22BBB00000
33CCC17341.48521.63 3448.987938.525432.35
44DDD09368.322345.1204458.98

 

I know how to create a customer filter for multiple columns. But in this case i have multople measures.

 

Please help me to find the solution for this.

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Thejeswar Senior Member
Senior Member

Re: Filter on multiple measures

@Divya904,

Try creating another measure like the one below and use that as a visual filter for your table

 

Measure = IF([Age 1-20]=0, IF([Age 21-40]=0, IF([Age 41-60]=0,IF([Age 61-80]=0,0,1),1),1),1)

View solution in original post

3 REPLIES 3
Thejeswar Senior Member
Senior Member

Re: Filter on multiple measures

@Divya904,

Try creating another measure like the one below and use that as a visual filter for your table

 

Measure = IF([Age 1-20]=0, IF([Age 21-40]=0, IF([Age 41-60]=0,IF([Age 61-80]=0,0,1),1),1),1)

View solution in original post

Divya904 Member
Member

Re: Filter on multiple measures

Hi Thejeswar,

 

Thank you so much for your help.

 

Please let me know do i need to create this measure as of Bollean type (true/false) or as whole number.

As a visual filter ,i have selected 'Show me all the iteams when value is 1".

Please confirm if my understanding is correct

 

Thanks.

Thejeswar Senior Member
Senior Member

Re: Filter on multiple measures

Yes. You can create it as either a Whole Number or a Boolean.

 

Yes you will have to set visual filter as equating to 1

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 45 members 961 guests
Please welcome our newest community members: