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

[Anonymous]

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 to all of them and also contains DQC_number.

I am trying to create a table visual which value should be dynamically changed based on the slicer selection from the other table.Meaning that if from the slicer the value 2 is selected,the table visual should show all rows from Errors2 and so on.

I see there is a way to do that with bookmarks,but I would like to do that with a DAX measure that would return me all rows from a certain table.

I have read somewhere showing all rows is not supported in report view,but maybe somebody have found a solution for that?

Thank you in advance for your answers.

[oritam3210]

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]

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.