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