Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
In the above image, I'm looking for a way to merge my "Measure Item No." and "Measure Parts No." tables together so when an "Item No." has a "Parts No." in it, only the information in "Measure Parts No." is filtered.
Else, if the information in "Parts No." is blank, the table would filter the measure information by "Item No."
Example,
How would you write this in DAX?
Data Model for current build,
Thank you,
Solved! Go to Solution.
I merged the two tables and found a better way to do it outside of DAX.
Thank you,
I merged the two tables and found a better way to do it outside of DAX.
Thank you,
Hi @SimonP19 ,
The data in the above picture are in a table? Which table vision is in which table? Could you please provide a pbix file without privacy information and desired output with more details ? (Or some sample data and a screenshot with the desired output)
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |