Filter The Records In The PowerBI

[win23]

I have three tables for the PowerBI report

1. 'table1' Which is having below columns

• id1
• name1

1. 'table2' Which is having below columns

• id2
• name2

1. 'table3' which is having below columns

• id3
• name3
• tempid

I have given dropdowns/slicers for 'table1'[id1] & 'table2'[id2]. I want to get the records from the 'table3' where 'tempid' = [Selected value of 'id2'] OR 'tempid' = [Selected value of 'id3'].

How to do that in the PowerBI.

[parry2k]

@win23 add a below measure and then filter on this measure where measure value = 1

Count Measure = 
CALCULATE ( 
    COUNTROWS ( Table3 ),
    Table3[TempId] IN { SELECTEDVALUE ( Table1[Id1] ), SELECTEDVALUE ( Table2[Id2] ) } 
)

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[vicky_]

You will need to use DAX. This guide has some code examples that you can easily adapt for your needs: https://apexinsights.net/blog/or-xor-slicing