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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.