Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago

Subtract values from same column

  Hi, Is there any calculation that I can do in a matrix table that would allow me to subtract one value in a column by another value in the same column?    I have attempted to do here but the val...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Assuming Amount is a measure that you have already written, write this measure

Measure = [Amount]-calculate([Amount],'apps'[app_cat]="YTL")

  • M_SBS_6's avatar
    M_SBS_6
    Icon for Helper V rankHelper V
    3 years ago

    Thanks for your suggestion. I have tried this measure but all that seems to happen is my value for "YTL" returns a 0. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      You are welcome.  What happens to the INT value?

      • M_SBS_6's avatar
        M_SBS_6
        Icon for Helper V rankHelper V
        3 years ago

        The same value remains, 100000.