Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
4 years ago
Solved

Table filter with two field condition

Dear all,   When we have table visual, how to set filter with 2 field with OR condition ? I have like this -> Both are Measures so both are already a calculation of some other original data...
Tips and Tricks
  • admin_xlsior's avatar
    admin_xlsior
    4 years ago

    Hi,

     

    This is solved. Just realized I actually only need to add those 2 measure with ABS() function for each. The result will be zero whenever both are zero, then I can use it in "Filter on this visual"

     

    Thanks.

admin_xlsior's avatar
admin_xlsior
Post Prodigy
4 years ago

Hi,

 

If possible, I don't want to have any addition table into it. Can we maintain this on the visual it self ? Because I think this is just a matter of display or not. But I hope I'm right.

 

So, as mentioned, this two value are measures and in my Table Visual only listed/display these two measure and 1 more from a dimension table related to that measure. 

 

So for example, Measure A and B are SUM of Gross and Net sales (from Order table) and the other column I included in that Table Visual is Customer (from Customer table which related to Order table). This is however only example, and what I needed is whenever the A or B has value, show the line, if both has zero value, hide it.

 

Hope it is more clear.

 

Thanks

 

 

 

 

 

admin_xlsior's avatar
admin_xlsior
Post Prodigy
4 years ago

Hi,

 

This is solved. Just realized I actually only need to add those 2 measure with ABS() function for each. The result will be zero whenever both are zero, then I can use it in "Filter on this visual"

 

Thanks.