Forum Discussion

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

v-jingzhang

Community Support

4 years ago

Hi MStP

Can you provide some sample data to help explain the expected outcome more clearly? Is there any relationship between two tables?

If you display data from Table B in a table visual, you can simply put PO Account Assignment column from Table B into the filter pane of this visual and set it to show items when value is 'K' or 'P' with Basic filtering type.

If the selected values from Table A are decided by other visuals based on user's interaction, you can create a measure like below to play as a visual-level filter field. Set it to show items when the value is 1. To use this measure, [PR Account Assignment] column should be displayed in the visual.

flag =
VAR __selectedValues = VALUES ( 'Table A'[PR Account Assignment] )
RETURN
    IF (
        SELECTEDVALUE ( 'Table B'[PO Account Assignment] ) IN __selectedValues,
        1,
        0
    )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.