Forum Discussion

aritaa01's avatar
aritaa01
Frequent Visitor
4 years ago
Solved

Custom Subtotal and Grand Total

Hi, I have 2 Measure such as Order and sales and Create New Measure Base on ABS (Order - Sales). Can i Custom the Sub Total for ABS(Order-sales) as shown below? Thanks  
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    aritaa01 , Assuming order and sales are measures. Try like

     

    sumx(summarize(Table, Table[category], Table[Product], "_1", ABS([Order] -[Sales])),[_1])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

aritaa01 , Assuming order and sales are measures. Try like

 

sumx(summarize(Table, Table[category], Table[Product], "_1", ABS([Order] -[Sales])),[_1])