'Having a max value on a gauge, not affected by filters

I am trying to create a gauge, which when I filter it, the max value doesn't change.

From my table, Table1, I have two fields, a CalendarDate and a BudgetAmount.

If I click on a month in the CalendarDate, I would like the Max value in the gauge to stay as the sum of all the BudgetAmount.

I created a measure as MaxBudgetAmount = CALCULATE(ALL(Table1[BudgetAmount])), but when I put this as the max value in my gauge, I get the following error:

Error Message: MdxScript(Model) (4, 72) Calculation error in measure 'Table1'[MaxBudgetAmount]: A table of multiple values was supplied where a single value was expected.

What am I currently doing wrong?

powerbi powerbi-desktop

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Having a max value on a gauge, not affected by filters

Sources

Related Questions