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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MiKeZZa
Post Patron
Post Patron

Problems combining 2 Tables

Hi guys,

I'm having problems combining 2 fact tables and a DAX-measure. Can you please help me to understand what we're doing wrong?

 

This is our datamodel:

 

And when we're making a combination of a field in a fact table and a summation of another field from another fact table it's ok:

 

problem_1.png

 

But when we don't want to sum the field but make a DAX-calculation for it something goes wrong:

problem_2.png

 

We really can't understand this. The DAX-formula is shown in this printscreen; as you can see it sums the uitbetaaldefte field, just like our first printscreen, but it divides it by something from the date dim. But this gives a strang multiplication of data; the person that had 1 'arbeidsrelatie' in first printscreen now has all the available 'arbeidsrelatie' choices plotted to it; this is not correct...

 

We think it happens because of combining 2 fact tables, but we also do this in printscreen 1 and there it gives no problem, so it is caused by our DAX-calculation. But even when we change the DAX to this the multiplication comes:

 

Aantalftes_Uitbetaald = 
            SUM ('edm uitbetaaldefte'[uitbetaaldefte])

But this DAX must be the same as the normal SUM.....

 

So we are really desperate... What are we understanding/doing wrong?

 

 

Our datamodel is:

problem_3.png

19 REPLIES 19

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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