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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
sbratton
New Member

dax query to filter one table based on information in another table

i'm fairly new to powerbi/dax and have been struggling to figure out how to filter one table based on information in another table.  Any help would be greatly appreciated.    For my first question i have 2 tables.  One table has Steps that people have decided to take.  They have the option of choosing suggested steps - so some steps will have a suggested_step_id.  Suggested Steps are in another table and all have a locale (ie langugage).

I would like to find out all the people (distinct person_id) who have steps with a locale of es-419

Screen Shot 2020-10-21 at 9.57.16 AM.png





My second question builds on the first.

People can also be members of groups. 

I would like to find all the groups that contain people who have steps with locale es-419.

Screen Shot 2020-10-21 at 10.03.07 AM.png

1 REPLY 1
edhans
Super User
Super User

You would relate them via the ID field most likely and use the FILTER function in a measure to limit the data in a measure. If there were no unique keys to create a relationship from, then you can use LOOKUPVALUE() with disconnected table.

 

We'd really need some data to make sure we are clear on what is in those fields, and a good example of what your expected result is though. See links below for providing data.

 

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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