cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
rudisoft
Frequent Visitor

Ignore slicer in measure

Hi there, seems I have also a problem with ignoring a slicer when creating a measure.

 

This is my measure that looks for projects with business goal "baseloads": 

c = calculate(COUNTROWS('MP Rep Projects'),FILTER(all('MP Rep Projects'), 'MP Rep Projects'[BusinessGoalShort]="BL")) results into 35 projects.
 

Now I add a slicer onto a page (interactions enabled) that will filter for a project and the measure will be zero as soon as a project (non BL) is selected. In case the interaction is disabled, the measure doesn't change. I however don't want to disable the interaction (as it filters a project list down to a single project) but the value should remain the count pf baseload projects.

 

Isn't it that this ALL should work?

 

 

2 REPLIES 2
rudisoft
Frequent Visitor

So we have a project dashboard created from Jira data and the user selects a project here (A):

rudisoft_0-1679670085218.png

This will filter for the content that is specifically related only to this project, which is exactly what we want.

One of the project's data fileds is the rank (negative 35 here) which comes from a data source named Meisterplan.

 

MP rank =
var r =CALCULATE(SELECTEDVALUE('MP Rep Projects'[rank]),USERELATIONSHIP('MP Rep Projects'[epic key],'Jira Epics'[issue key]))
//var c = calculate(COUNTROWS('MP Rep Projects'),FILTER(all('MP Rep Projects'), 'MP Rep Projects'[BusinessGoalShort]="BL"))
//var d = calculate(COUNTROWS('MP Rep Projects') , filter(ALLEXCEPT( 'MP Rep Projects' ,'MP Rep Projects'[BusinessGoalShort] ),'MP Rep Projects'[BusinessGoalShort]<>"BL"))
return r -35

 

The statement

var c = calculate(COUNTROWS('MP Rep Projects'),FILTER(all('MP Rep Projects'), 'MP Rep Projects'[BusinessGoalShort]="BL"))

will only result in 35 when (A) is not selected. When (A) is selected, c will always be zero.

The relation itself couldn't be simpler:

rudisoft_1-1679670943357.png

 

 

v-binbinyu-msft
Community Support
Community Support

Hi @rudisoft ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors