Forum Discussion

MStP's avatar
MStP
Helper I
4 years ago

Filter Measure from Two Tables

Hello Everyone,   I want to create a measure that will be applied as visual-level filter. This will use one column from Table A and one column from Table B. The conditions are:   Table A: Column...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Share some data, explain the question and show the expected result.

  • MStP's avatar
    MStP
    Helper I
    4 years ago

    Hello Ashish_Mathur 

     

    As posted above, in reply to your message:

     

    Please see the link for the sample data file below.

     

    I want to create a measure that acts as a visual level filter to include the following rows:

     

    PO Cat = K or P

    PO Cat = Blank, and PR Cat is K or P

     

    In the sample data, the desired result is that the filter excludes PO1003.

     

    https://drive.google.com/file/d/1XOp8YVIYCD71NXyVb3Oe_2lRT7FXUWgl/view?usp=sharing

     

    Please let me know if you need additional information.

     

    Michael