Filter Page or Report based on Other Field

[MarkDGaal]

Hi guys, I'm seeing if there is anyway that I can express a page or report level filter that applys only when the value in one field is less than or equal to the value in another field. From what I can tell you can only enter "valid values" into the advanced filtering options; however, I was hoping that there was a workaround that didn't invovling me going into my query and creating 5 conditional columns for when a <, >, <=, >=, or = situation exists. Thanks in advance

[sornavoor · Accepted solution]

Suggest doing the following. 

a)  Create a Measuse with DAX  reflecting a the required filter criteria some thing like below; You may get to as complicated as you wish here; .

     MyCustomFilter = IF(Table1[Column1] < Table1[Column2], "True", "False")

b) Use the "MyCustomFilter"   whereever you need. 

Hope the suggestion helps solves your requirement.

[MarkDGaal]

Of Course, duh, Thank You. Would be nice if MS just include the ability to add fields into the values only box.

[sornavoor]

Agree that MS  should enable this -  Please feel free to add to requested Ideas  and see where it goes.