Forum Discussion

Mohammadwazeri's avatar
Mohammadwazeri
Helper III
3 years ago
Solved

How To Subtract

Hi Guys, Could you please help me?  How to subtract Total USD from GRPO Total USD and then subtract the result (Remaining USD) from the second row of GRPO Total USD again subtract the result (Remai...
  • parry2k's avatar
    3 years ago

    Mohammadwazeri try this measure

     

    Measure = 
    SUM ( 'Table'[Total] ) - 
    CALCULATE ( 
        SUM ( 'Table'[GPRO] ),
        FILTER ( 
            ALL ( 'Table' ),
            'Table'[No] <= MAX ( 'Table'[No] )
        )
    )

     

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • parry2k's avatar
    3 years ago

    Mohammadwazeri share DAX expression you are using, and make sure the index column is in the visual:

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • parry2k's avatar
    3 years ago

    Mohammadwazeri change ALL to ALLSELECTED

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.