Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

measure which not filtered by slicer

I need application measuer which not filtered with slicer. I try below measuer but not work: In Reprot I have one slicer Delinquency  and I don't want to filterd with this. 

 

#Measure 4 = CALCULATE(SUM(MLlnput[Payments]),ALL(MLlnput[Delinquency Bracket])) 
 
Screenshot3.png
9 REPLIES 9
themistoklis
Community Champion
Community Champion

@Anonymous

 

Try the following formula:

 

#Measure 4 = CALCULATE(SUM(MLlnput[Payments]), ALL(MLlnput)) 
Anonymous
Not applicable

@themistoklis

If I used "all" it also not fitter with Date in table view. I want to filter with Date but not Slicer.

@Anonymous

 

Try this:

 

#Measure 4 = CALCULATE(SUM(MLlnput[Payments]), ALLEXCEPT(MLlnput, MLlnput[Date])) 
Anonymous
Not applicable

@themistoklis I try this one still not give correct result. 
Screenshot_13.png

@Anonymous

 

Any chance to share the workspace with us?

 

I find it very strange because you use ALLEXCEPT

Anonymous
Not applicable

@themistoklis

 

I can't share work space because live data. But if you want I can on Skype and show workspace via share screen. 

@Anonymous

 

Another option is to use Edit Interactions.

 

Click on the Slicer and then move to Format on the Tab on Top and Edit Interactions.

 

You can then select tables this slicer can affect and which wont.

 

The icon to use is the following:

image.png

 

 

Anonymous
Not applicable

@themistoklis

 

Thanks But problem is this I want use this As tool tip. I can use this Edit intrections option. only measuer will help in my case. 

Anonymous
Not applicable

Hi @Anonymous

 

Did you find a solution ?

 

I have exactly the same problem as you ...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.