cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcopaz
Frequent Visitor

Measure that Ignore a Specific Slicer

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:

 

marcopaz_0-1679791226905.png

 

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")

 

1 ACCEPTED SOLUTION
marcopaz
Frequent Visitor

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

View solution in original post

1 REPLY 1
marcopaz
Frequent Visitor

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors