Forum Discussion

naftycs's avatar
naftycs
Regular Visitor
4 years ago

subtract

Hello:

I have a question, How can I substruct measures and create a new measure.

Measure diff = CALCULATE(SUM('Table_query__1'[Measure dl Complete Count])+[Measure dl In progress On Track]-CALCULATE(SUM([Measure dl In progress Past Due])))

Appreciate your help.

Thanks

Need Help

5 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi naftycs 
    Like this 

    [Measure dl Complete Count] + [Measure dl In progress On Track] - [Measure dl In progress Past Due]

    • naftycs's avatar
      naftycs
      Regular Visitor
      4 years ago

      Exactly I did that unfortunately do not see any number and error message.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi naftycs 

    Thanks for reaching out to us.

    Could you please provide sample data and the expected outcome? Then we can check your measure diff according to it.

     

    Best Regards,

    Community Support Team _Tang

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