Measure is creating duplicates

[NavaneethaRaju]

Hi,
I created one measures, its return duplicates while i'm using columns in from another table.
And also its returning the wrong values.

CALCULATE(SUM('Procedure Fact'[C501B_QTY]),ALLEXCEPT('Tag Usage Fact','Tag Usage Fact'[TAG_ID]))

can you guys advice any measure to find sum value respective of particular column data.

[v-zhangti · Accepted solution]

Hi, @NavaneethaRaju 

Measure:

Measure 1 = CALCULATE(SUM('Table'[QTY]),ALLEXCEPT('Table','Table'[ID]))

Measure 2 = CALCULATE(SUM('Table'[QTY]),ALL('Table'))

Measure 3 = CALCULATE(SUM('Table'[QTY]))

Which result is your desired outcome? If none of them is correct, please tell us the output result you expect.

Best Regards,

Community Support Team _Charlotte

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

[tamerj1]

@NavaneethaRaju 

Please clarify the problem. Does this table explain the problem or show the expected result?