Filtering one Table by two filters with a blank condition

[SimonP19]

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, 

[SimonP19 · Accepted solution]

I merged the two tables and found a better way to do it outside of DAX. 

Thank you, 

[Anonymous]

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.