Forum Discussion
Not filtering correct in UNION
Hello all, Maybe this is an easy take, but I'm facing some issues. I have 2 tables that together form the third table with the UNION function in DAX. Take a look at tables below: Table 1 ...
Hi Anonymous ,
If you want to use two filters to display the filtered results on a single table, you first need to make sure that there is no relationship between these two tablesCreate a measure
Is Fittered = IF( SELECTEDVALUE('Table 3'[Row]) IN VALUES('Table 1'[Row]) || SELECTEDVALUE('Table 3'[Row]) IN VALUES('Table 2'[row]), 1, 0 )Apply the measure to the Table 3
Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
"when I filter 1 row from table 1" - where are you doing this?