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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Wozniak27
Frequent Visitor

Matrix with data from two related tables

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? 

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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

1 REPLY 1
edhans
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.