Gauge visual Maximum value not affected by ALL()

[Anonymous]

Hello everybody,

I thought this was a simple thing, but for some reason, it just isn't.

I have a Gauge visual with a sum of [BUD] as Maximum value.
I want this number to be affected by all the slicers and filters except one - month.

I thought this measure would work:

MAX BUD = CALCULATE(sum(Master[BUD]), ALL(Master[Month]))

Master is the name of the table
BUD is the name of the column I'm summing.

For some reason, if I filter in a slicer with the month I have, it still affects the Maximum value.

Can somebody, please, tell me why?

[Anonymous · Accepted solution]

Hello,

I managed to find a solution.

I have 4 different slicers on the page. One of them is month and it's the only Slicer I didn't want to affect the Max Value in the Gauge visual.

MAX BUD = CALCULATE(sum(Master[BUD]),ALLEXCEPT(Master, Master[Slicer1Value], Master[Slicer2Value],Master[Slicer3Value))

Month is the only one that is not included in the slicer and it works.

For some reason I thought ALL() and ALLEXCEPT() were inverse function therefore the ...ALL(Master[Month])) function should work, but it doesn't.

Anyway, it's solved and working now. Not an ideal solution, but more of a workaround.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Anonymous]

Hi @v-zhangti  and @amitchandak ,

Thanks for your tips, unfortunately, none of the solutions is working.
I tried both but the Max Value is still affected by the Slicer with Months.

I want the Max value to display the year's 100 % target value.

I want the Month slicer to affect the Callout value but the Max value should be fixed. (but affected by other slicers than month slicer)

Any other ideas?

[v-zhangti]

Hi, @Anonymous 

You can try the following methods.

MAX BUD = CALCULATE(sum(Master[BUD]),ALLEXCEPT(Master,Master[Date]))

The maximum value is not affected by the month slicer, it is affected by other slicers. Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Based on what I got, Try like

MAX BUD = CALCULATE(sumX(values(Master[Month]) , calculate(Sum(Master[BUD]))) , ALL(Master[Month]))