Forum Discussion

Divya904's avatar
Divya904
Icon for Helper III rankHelper 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, ...
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)
Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper 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
    Icon for Helper III rankHelper 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
      Icon for Super User rankSuper 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