Translate value into a table (after use this table as max value for a gauge)

[krazyesko]

Hi PBI community, 

quick question : Translate value into a table (after use this table as max value for a gauge)

this is a result from a measure that return week revenu : i need those number to been set into a colonm - cause after that i can setup a min / max value. but since it a measure i cannot apply an another fonction.

in this exemple max value would be 28k - so we can compare each vs other using gauge like that.

thanks - let me know if you don't really understand my demande - english is not my primary langage.

[amitchandak]

@krazyesko , You can use the column itself and use min/max option. Or create new measures for min max

[krazyesko]

the value in the column himself is a measure that sum sale from location. so if i do that the min would be 1$ and max 200$ ishh. but i look foward to have 10k & 28k like in the table result 

thanks for reply tought