Calculated Column With The Total value of a measure when Slicing different periods

[rmeng]

I´m using this measure to add a calculated column, when I select from Dim Date the Quarter Year option, the result is 4 as expected:

If I slice by Month Year instead of Quarter Year this Calculated column should be 2 not 4 

I´ve tried to use AllExcept to keep filters from dim date but the result is 1:

Could you help me to find the right calculation ?

Thanks

[johnt75 · Accepted solution]

Calculated columns are only calculated during data refresh, so they do not pay any attention to filters or slicers which may be set in a report. If you want something to dynamically respond to slicers you need to define it as a measure.