Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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??
Hi,
Something like this
Measure = calculate([Measure],all(data[Offices]))
😂
Again???
You again do not see the difference betwen the two????? I have used ALL and you have used Removefilters.
@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
Iti s just a different way to solve a probelm. Don't you get it?????
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???
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! 🙂
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |