Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago
Solved

hi

hi 

 

I need a measure that can add budget s Actual MR (Monthly) Quantity Measure Cell Values

Budget vs Actual MR (Monthly) Sale is a measure

 

Budget vs Actual MR (Monthly) Sale = '1. Measure Table- Retail'[Total Sale With VAT (Taka) (Measure)] - [Monthly Budget MR (Sale)]
 

 first 6 cell adding values should be (5,273.76 + 7,002.05 + 3,159.49 + 1,932.43 - 4,481.87 - 4,481.87)=  8,403.99

 

not 30,813.34 as this calculation comes from another two table subtrack to Budget vs Actual MR (Monthly) Sale

 

thanks

Need Help
  • abc_777's avatar
    abc_777
    3 years ago

    hi v-easonf-msft ,

     

    thanks for your solution it works.

     

    but i want to keep subtotal for this column not grand total. 

    for other column i want to keep sub total and keep grand total

     

     

    thanks

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    3 years ago

    Hi, abc_777 

    Which fields are you applying to the ’Rows‘ of the matrix ?

    Please add another measure like:

    New Budget vs Actual MR (Monthly) Sale  = SUMX(VALUES('Table'[MonthInCalendar]),[Budget vs Actual MR (Monthly) Sale])

    Best Regards,
    Community Support Team _ Eason

    • abc_777's avatar
      abc_777
      Solution Specialist
      3 years ago

      hi v-easonf-msft ,

       

      thanks for your solution it works.

       

      but i want to keep subtotal for this column not grand total. 

      for other column i want to keep sub total and keep grand total

       

       

      thanks