Forum Discussion

Divya904's avatar
Divya904
Helper III
8 years ago
Solved

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

 

Need Help
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    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)

3 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    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's avatar
      Divya904
      Helper III
      8 years ago

      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's avatar
        Thejeswar
        Super User
        8 years ago

        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