The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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.
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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
14 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |