Relationship Causing Duplicates in Measure and Giving Incorrect Total

Anonymous — Thu, 06 Jun 2024 07:00:53 GMT

There are 3 Tables, Dim, Tab1, and Tab 2 with the relationship defined below,

Dim Table:

Key

Tab1:

Tab2:

The desired output is to get

Tried using the measure

CALCULATE(SUMX(Tab2,Tab2[Data]), ALLSELECTED(Dim[Key]))

end up with duplicate values and Cross join of the table with the DIM giving

C
C

D
D
D

What is the reason behind the duplication and how to correct it?

Re: Relationship Causing Duplicates in Measure and Giving Incorrect Total

Anonymous — Fri, 07 Jun 2024 01:50:30 GMT

Hi Anonymous

You can use the append feature in PowerQuery to implement your needs.

When you add the "ref" column to the table, the result can only be like this:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.