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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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