Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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   ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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 tables

    Create 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 He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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 tables

Create 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 He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly