Filter on multiple measures

[Divya904]

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 Name	Total	Age 1-20	Age 21-40	Age 41-60	Age 61-80
11	AAA	13692.50	321.63	0	7938.52	5432.35
22	BBB	0	0	0	0	0
33	CCC	17341.48	521.63	3448.98	7938.52	5432.35
44	DDD	0	9368.32	2345.12	0	4458.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

[Thejeswar · Accepted solution]

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

[Divya904]

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]

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