Forum Discussion
Helper IVMeasure is creating duplicates
Hi,
I created one measures, its return duplicates while i'm using columns in from another table.
And also its returning the wrong values.
can you guys advice any measure to find sum value respective of particular column data.
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.
2 Replies
- tamerj1
Community Champion
Please clarify the problem. Does this table explain the problem or show the expected result?
v-zhangtiCommunity Support
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.
