Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filtering 2 tables

I have 2 tables in power bi as you can see in the screenshot. the first table has column asset and data points, and the second also has these 2 plus a dashboard name column. when i choose a s...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    yes i made the relation between both tables with asset. the solution here is to create a dax measure that passes in the column "required points" and checks the strings in it if they match the column "data points". here's the dax query:

    Filter Measure =
    VAR SelectedDataPoint = SELECTEDVALUE('Automated'[Data Points])
    RETURN
    SUMX(
                'Dashboard Selection Updated',
                IF(

                     CONTAINSSTRING('Dashboard Selection Updated'[Required points], SelectedDataPoint),
                     1,

                     0

              )

    )

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Anonymous 
Make sure you have proper relationship with above 2 tables.

 

I hope I answered your question!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    yes i made the relation between both tables with asset. the solution here is to create a dax measure that passes in the column "required points" and checks the strings in it if they match the column "data points". here's the dax query:

    Filter Measure =
    VAR SelectedDataPoint = SELECTEDVALUE('Automated'[Data Points])
    RETURN
    SUMX(
                'Dashboard Selection Updated',
                IF(

                     CONTAINSSTRING('Dashboard Selection Updated'[Required points], SelectedDataPoint),
                     1,

                     0

              )

    )