Help with a delta measure for total

[Anonymous]

Hello all,

I am trying to get the delta in this Total column and not the sum. I figure this would be something straight forward to do, but I am not able to find anything or figure it out. Can someone point me in the right direction? Thank you!

[amitchandak]

@Anonymous , use isfiltered or isinscope and change GT

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[Anonymous]

I can't seem to get the isfiltered to work and what is GT? This is how my dax formula looks 

Diff = IF ( ISFILTERED ( Table[Date] ), SUM ( Table[Amount] ), CALCULATE ( SUM ( Table[Amount] ), VALUES ( Table[Company] ), Table[Date] = 201806 ) - CALCULATE ( SUM ( Table[Amount] ), VALUES ( Table[Company] ), Table[Date] = 201807 ) )

Thank you @amitchandak  for the help! 

[Anonymous]

Hi @amitchandak, any recommendations from my last post?