Sum profit with two filters

[Uday02]

Hi All,

The dataset that I'm using has a profit column that contains both profit and loss numbers.
Now I am trying to evaluate Total Profit by filtering the column with values greater than 0 and loss with values less than 0.

But I have to specify another condition that whenever I am filtering the data through a slicer it should not impact my Total Profit card visual.

Now I can do that by editing interactions but I want to achieve it by using Dax.

OrderBreakdown and Calendar Tabales do not have a relationship 

Thank you in advance.

Calculations using DAX 

[ToddChitt · Accepted solution]

Not sure on this, but I think it might be something like:

[My Measure] = CALCULATE ( SUM ( 'table'[column] ), ALL ('table 2'[column you don't want affecting the filtering]) )

(sorry for the 'air-ware')

Hope this helps

[Uday02]

It worked. Thank you so much.