Cumulative Sum of Total Savings

[Majidbhatti]

Hi,

I have 3 columns "Current Price", "Previous Price" & "Savings". The formulas are as below.

Current Price = 
CALCULATE(PurchaseReceipts[Total Invoice wo Tax]/Sum(PurchaseReceipts[qty]))


Previous Price = 
CALCULATE(PurchaseReceipts[Current Price], PREVIOUSMONTH(DateTable[Date]))


Savings = 
    If(HASONEFILTER(Products[Product Name]),
        If(
            OR(isblank(PurchaseReceipts[Current Price]), 
                isblank(PurchaseReceipts[Previous Price])),
            blank(), 
            PurchaseReceipts[Previous Price] - PurchaseReceipts[Current Price]
        ),
        CALCULATE(
            PurchaseReceipts[Previous Price] - PurchaseReceipts[Current Price],
            ALLSELECTED(PurchaseReceipts) ,VALUES(Products)
        )
    )

The problem is evident, I need totals of the "Savings" column and BLANKS in "current price" & "previous price" as shown below

[Majidbhatti]

Hi @smpa01 

Were you able to see the pbix file?

[smpa01]

@Majidbhatti  is it kindly possible to post a sample pbix please?

[Majidbhatti]

Hi @smpa01 

Savings needs to be totalled at all the ROW Groups. 

The file is available here