Measure ignore slicer filter

[3186564]

Hi,

I have been asked to plot student grades across labs as a line chart. There will also be a minimum, maximum, and average grade line that I have created as measures, and a slicer that can filter students which appear on the visualisation. However when a subject on the slicer is selected the min, max, and avg lines are also altered by the slicer. Is there a way around this? I have tried using the ALL() function, but had no such luck. Thanks.

[3186564]

Hi,

I have been asked to plot student grades across labs as a line chart. There will also be a minimum, maximum, and average grade line that I have created as measures, and a slicer that can filter students which appear on the visualisation. However when a subject on the slicer is selected the min, max, and avg lines are also altered by the slicer. Is there a way around this? I have tried using the ALL() function, but had no such luck. Thanks.

[v-jiascu-msft · Accepted solution]

Hi @3186564,

The all() could work like this: 

min = calculate(min('table'[grade]),
                           all('table'[subject]))

Could you please post your formulas here? 

Best Regards!

Dale

[3186564]

Thanks Dale,

Not sure what I was doing wrong before, but this seems to work,

cheers.