cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Super User II
Super User II

Re: Matrix with data from two related tables

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
Super User II
Super User II

Re: Matrix with data from two related tables

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors