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])

2 Replies