Filtered measure that ignores a slice

Hi oscarmqz ,

First create an unrelated Cycle table as slicer.

Then create a measure like this :

measure =
VAR mSavingsDelta =
    CALCULATE (
        SUM ( 'CIP-ReportingDataNEW'[Savings (K$)] ),
        'CIP-ReportingDataNEW'[Source] = "Current"
    )
VAR selectedvalue_ =
    CALCULATE (
        SUM ( 'CIP-ReportingDataNEW'[Savings (K$)] ),
        FILTER (
            'CIP-ReportingDataNEW',
            'CIP-ReportingDataNEW'[Cycle] = SELECTEDVALUE ( 'TABLE'[Cycle] )
        )
    )
RETURN
    mSavingsDelta - selectedvalue_

If the problem persists,could you share the sample pbix or sample data?

Please mask any sensitive data before uploading

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.