Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Wozniak27
Frequent Visitor

Matrix with data from two related tables

‎03-27-2019 01:39 PM

Hi everyone!  I currently have two related tables merged utilizing the fuzzy merge and transformation table feature.  I am trying to build out a matrix that pulls data from both related tables, but not all the data is coming through.  It seems as though any data that ties back to the transformation table is not carried over to the matrix.  Has anyone encountered a similar issue? 

Labels:
Message 1 of 2
502 Views
0
1 ACCEPTED SOLUTION
edhans
Super User
Super User

‎03-27-2019 02:50 PM

Fuzzy merge is part of Power Query and does not carry over into the data model as a relationship. You cannot relate tables in DAX with fuzzy merge. So if you have data that isn't an exact match, DAX won't relate it.

 

If you want it in the DAX data model either:

  • fix your source data or fix through a transformation in Power Query or
  • merge the data in Power Query using fuzzy merge, then bring that single table into DAX.


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

View solution in original post

Message 2 of 2
493 Views
1 REPLY 1
edhans
Super User
Super User

‎03-27-2019 02:50 PM

Fuzzy merge is part of Power Query and does not carry over into the data model as a relationship. You cannot relate tables in DAX with fuzzy merge. So if you have data that isn't an exact match, DAX won't relate it.

 

If you want it in the DAX data model either:

  • fix your source data or fix through a transformation in Power Query or
  • merge the data in Power Query using fuzzy merge, then bring that single table into DAX.


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
Message 2 of 2
494 Views

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

View All