Measure that Ignore a Specific Slicer

[marcopaz]

Hello, I am trying to create a graphic that plots two S-Curves that compares % Earned vs % Duration:

1- S-Curve with Completed/Inactive projects that look into my dataset, and brings the Average of % Earned for a given % Duration.

2- S-Curve for one selected Active Project that brings the current % Earned for a Given % Duration

The idea is for me to be able to compare my current projects to Historical Previously Completed projects, and see how the active project is performing against the average of historical projects. I managed to generate the graphic below, which is exactaly what I am looking for:

I do have one problem with Slicers, I wanted to have two different slicer patterns for the same visual:

1- For the Active Project S-Curve, I want to be able to select a specific Contract ID which will draw the S-Curve for the Active Project

2- For the Inactive Project S-Curve, I don't really want it to be filtered by Contract ID, but by other Filters such as "Contract Amount", "Project Type" etc. So the idea is that my client will select some criterias of similar projects of my dataset that will be used to be compared to the Active one.

So I am strugling because I don't know how to make these slicers work idependently for the same visual under two different Measures. I've tried many filter functions, such as ALL, ALLEXCEPT, etc but if I select a Contract ID for an Active Project, the S-Curve for Inactive also gets filtered out. My current solution is to select all project (Active+Inactive) and create a filter inside their measures that filters if they Active or Not. See below:

S-Curve Active Project = 
CALCULATE(
    AVERAGE(fEarnings[S-Curve Max Cumulative Earned]),
    FILTER(fEarnings,fEarnings[ClosestDurationPercentage]<=MAX('S-Curve DurationSequence'[DurationPercentage])),dProjects[Active]="Yes")

S-Curve Inactive Projects = 
CALCULATE(
    AVERAGE(fEarnings[S-Curve Max Cumulative Earned]),
    FILTER(fEarnings,fEarnings[ClosestDurationPercentage]<=MAX('S-Curve DurationSequence'[DurationPercentage])),dProjects[Active]="No")

[marcopaz · Accepted solution]

I actually found a solution, just need to create "disconnected tables" that aren't linked into the data model, and it did work perfect