Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
hussein_c
Frequent Visitor

Filtering 2 tables

test.pngI 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 specific asset from the first table, the second table also filters according to that asset. for example, if i choose chiller from table 1, table 2 will filter to display chiller as well. as for the data points and required points, when i choose a data point from table 1, it wouldn't display the same data point in table 2, because in table 2, the row contains multiple data points, but i want when i choose 1 point from table 1, to show the row that contains that point, even if it's with another point. how can i do it? 

1 ACCEPTED SOLUTION

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

          )

)

View solution in original post

2 REPLIES 2
Uzi2019
Super User
Super User

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

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

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

          )

)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.