Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Total calculation

Hi Experts   i have one question as below table data. the total calcuation is not expected result.  i want to calculate impact field which unit price variance multiply the actual volume, and the e...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , You need to force row context to get the correct total, Assuming both [Unit Price Variance], and [Volume] are measures. or clear those

     

    Sumx(Values(Table[Category]), [Unit Price Variance] *[Volume] )

amitchandak's avatar
amitchandak
Super User
2 years ago

Anonymous , You need to force row context to get the correct total, Assuming both [Unit Price Variance], and [Volume] are measures. or clear those

 

Sumx(Values(Table[Category]), [Unit Price Variance] *[Volume] )

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks 

    but i have one issue here, actually there are 2 dimensions  channel and category. 

    for the channel sub total it is working, but the grand total is not working.