Dynamically change rows in a table based on slicer selection from another table

Hi all, I have the following scenario here.I have 13 tables and each table contain the field DQC_number.Let's call them Errors1,Errors2,Errors3 and so on.I have another table that has relationship t...

oritam3210

Helper I

2 years ago

Hi Anonymous ,
I think the best way to implement this is to union all the error tables into one table and to add a column that indicates the source table.

srcTalbe	column a	column b	column ....
Error1
Error2
error ...

you can do it with the UNION DAX function

UNION(
    ADDCOLUMNS(
        Error1,
        "SrcTable","Error1"
        ),
    ADDCOLUMNS(
        Error2,
        "SrcTable","Error2"
        ),
    ADDCOLUMNS(
        Error...,
        "SrcTable","Error..."
        )
)

Good Luck

---------------------------------------------------------------------------------------------------------------------
If you find this helpful, kindly consider marking it as 'Accepted Solution.'
This action helps others quickly find a reliable answer!

Anonymous

Not applicable

2 years ago

Hi,

thank you for trying to help me.I think union wouldn't be helpful in this scenario since the tables have different type of columns and different amount of rows.

Forum Discussion

Dynamically change rows in a table based on slicer selection from another table