Forum Discussion
Solved
Filtering on Column in a Calculated Table by Others Column in distinct Tables
Hi all, need a big help on this request. 1- I have a table called 'Transactions Table' that needs to be filter by 'Table Filter 1' and 'Table Filter2' 2- I need the Order Numbers on 'Table Filter ...
Hi JSIQUEI-YYC-ENB ,
My Sample:
Please try code as below to create a meausre. Then you can add this measure into visual level filter and set it to show items when value = 1.
M1 = VAR _Table1 = VALUES ( 'Table Filter 1'[Order Number] ) VAR _Table2 = VALUES ( 'Table Filter 2'[Order Number] ) RETURN IF ( OR ( MAX ( 'Transactions Table'[Order Number] ) IN _Table1, MAX ( 'Transactions Table'[Order Number] ) IN _Table2 ), 0, 1 )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JSIQUEI-YYC-ENB ,
My Sample:
Please try code as below to create a meausre. Then you can add this measure into visual level filter and set it to show items when value = 1.
M1 =
VAR _Table1 =
VALUES ( 'Table Filter 1'[Order Number] )
VAR _Table2 =
VALUES ( 'Table Filter 2'[Order Number] )
RETURN
IF (
OR (
MAX ( 'Transactions Table'[Order Number] ) IN _Table1,
MAX ( 'Transactions Table'[Order Number] ) IN _Table2
),
0,
1
)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thanks a lot... that's helped!