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
IZJT76
New Member

Exclude specific value from being filtered via Slicer

I have a dataset of audit scores for our offices - our audits consist of 18 seperate 'sections' with each section getting a score between 0-4.  The visual below shows the offices' value for each audit section (bars) being overlaid with the average of that value (line) so we have an average company benchmark in each section.

What I'd like to do is stop the Company Average line changing when I use a slicer to select different offices - so the bars move up/down as we slice between offices but the line stay constant, so we can compare each office's performance against overall company average.

Is there an easy way to do this??

 

Screenshot 2022-08-02 224540.jpg

 

8 REPLIES 8
Ashish_Mathur
Super User
Super User

Hi,

Something like this

Measure = calculate([Measure],all(data[Offices]))


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

😂

 

Again???

You again do not see the difference betwen the two?????  I have used ALL and you have used Removefilters.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur why did you think your input was necessary in the first place??? THAT IS THE POINT!!!  There are lots of logically equivalent ways to write measures, ranging from elegant to outright dumb.

There have been discussions in Super User meetings about respecting boundaries, not stepping on each others' toes, etc.  Most people respect those boundaries.  I've had instances where two of us replied to a question within seconds of each other, and I've said "that guy knows more, listen to him".  I've also had instances where people I thought better than I am have deferred to me because we replied at almost the same time.

 

But there you go, keep poaching.  🙄

 

Public shaming

@Greg_Deckler

@AllisonKennedy 

@parry2k 

@mahoneypat 

@heather_Itelent

Iti s just a different way to solve a probelm.  Don't you get it?????


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

No, I don't.  Please explain it to me in pedantic detail so myself, the other Super Users and platform administrator can understand.

Logically equivalent responses...why the need to reply???

Public shaming

@Greg_Deckler

@AllisonKennedy 

@parry2k 

@mahoneypat 

@heather_Itelent

 

Good on you @Ashish_Mathur : providing solutions already offered.  

littlemojopuppy_0-1659489486480.png

 

littlemojopuppy
Community Champion
Community Champion

Hi @IZJT76 

 

You have a measure for the line (I assume).  If so, modify it like this (and if you don't make one like this)

 

CALCULATE(
    [Existing Line Measure],
    REMOVEFILTERS(Tabl;e[Office])
)

 

Not syntactically perfect because I don't know the measure name or the table/field for office.  But if you follow that pattern, you should get what you're looking for.

 

Hope this helps!  🙂

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.