Forum Discussion
Helper IIIFilter Page or Report based on Other Field
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
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.
3 Replies
sornavoorResolver I
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.
