Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 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.

 

DAX

2 Replies

  • oritam3210's avatar
    oritam3210
    Icon for Helper I rankHelper 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.

    srcTalbecolumn acolumn bcolumn ....
    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's avatar
      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.