Forum Discussion

NavaneethaRaju's avatar
NavaneethaRaju
Icon for Helper IV rankHelper IV
4 years ago
Solved

Measure 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. CALCULATE(SUM('Procedure Fact'[C501B_QTY]),ALLEXCEPT('Tag...
Need Help
Need Help DAX
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

NavaneethaRaju 

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