Forum Discussion

fleed's avatar
fleed
New Member
8 years ago
Solved

Gauge chart with fixed max value

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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • crwinchester's avatar
      crwinchester
      Advocate I
      3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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])