Forum Discussion

MarkDGaal's avatar
MarkDGaal
Icon for Helper III rankHelper III
10 years ago
Solved

Filter 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 c...
  • sornavoor's avatar
    sornavoor
    10 years ago

    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.

     

     

     

     

sornavoor's avatar
sornavoor
Icon for Resolver I rankResolver I
10 years ago

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's avatar
    MarkDGaal
    Icon for Helper III rankHelper III
    10 years ago

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

    • sornavoor's avatar
      sornavoor
      Icon for Resolver I rankResolver I
      10 years ago

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