Help declaring max value measure for a guage?

Hi, 

According to your description, I can clearly understand your requirement, you want to create a gauge chart to display the comparison between your maximum capacity number and current capacity number, right? I think you can achieve your requirement by creating some measures like this:

This is the test data I created based on your description:

maximum capacity number =

MAX('reservations'[capacity number])

Current capacity numbers = COUNT(reservations[buildings])

Max = maxX(ALL(reservations),[capacity number])

Min = 0

And you can create a gauge chart and place it like this, then you can get what you want, like this:

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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