Gauge chart with fixed max value

[fleed]

I would like to configure the Gauge chart as follows:

- maximum value = count of items in a table

- value = count of filtered items

setting the same column (Id from a database table) for both Maximum and Value shows always the current count (filtered items) as max, but I would like to keep a fixed max (ignoring filters).

Is it possible?

Thank you

[v-yuezhe-msft · Accepted solution]

@fleed,

You can create a measure using ALL() function to calculate the max value, ALL() function ignores all slicers and visual/page/report filters. If you have any question about the DAX, please share sample data of your table here. 

Regards,
Lydia

[syvorov444]

sorry, I try using All() but still MAX VALUE in gauge change with filter(date).  DAX: CALCULATE(SUM('test_sales'[revenue]), ALL('test_sales'[revenue])

[crwinchester]

What about the Minimum value? How do you create that in order for this to be fixed even when filtered?