Multiple Guages, Different Where Clause

[Lisa2]

Hello,

I need to make three gauge charts. They will all use the max number of column B but where each gauge equals a different value from column A. I don't want a trellis chart. I don't know what should go in Dimensions (if anything) or what should go in Expressions or what settings should be set. If anyone could point me in the right direction. Thanks

Column A	Colum B
Average	45
Average	25
Minimum	78
Minimum	65
Maximum	23
Maximum	89

[Lisa_P · Accepted solution]

Use the expression:
Gauge 1
max({<[Column A]={Average}>}[Colum B])
Gauge 2
max({<[Column A]={Minimum}>}[Colum B])
etc

[Lisa2]

That didn't work.  I got the error "No data to display."  Was there supposed to be something in the Used Dimensions box under the Dimensions tab?

[Lisa2]

Never mind.  Syntax error.  Works great!  Thanks!