DAX : Complex filtering / union

[jct999]

Hello,

I have 3 tables :

TABLE1 : 2 columns

            BRAND_NAME

            VOLUME

TABLE2 and TABLE3 : 1 colum each

            BRAND_NAME

I have one slicer for TABLE2, and one slicer for TABLE3

TABLE2 and TABLE3 are « linked » to TABLE1 through BRAND_NAME columns, but I did not create relationship beetwen the tables in my model. (is it necessary?)

I want to calculate TABLE4 that gives me dynamicaly the rows from TABLE1 that are filtered/selected within TABLE2 (with its slicer) OR that are filtered/selected within TABLE3 (with its slicer). I would say that looks like an "union" query, without duplicates.

(Note that for some usecase reasons, I can't merge TABLE2 and TABLE3 in a single table...)

What is the DAX formula that can calculate this new TABLE4 ?

Regards

[Icey · Accepted solution]

Hi @jct999 ,

Calculated table won't change dynamically based on slicer. It is suggested to create a measure and a table/matrix visual to get what you want.

Please share us some sample data and the result you want. Then, we can conduct specific tests.

Best Regards,

Icey

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