Set Analysis - {1} to ignore current selections

[#1]

Hi

I am having difficulty with the following, can you help....

I am trying to create a display of 12 gauges. Each gauge representing the speed of a machine Today.

I also want to display against each of the 12 machines, a note of the Best and Worst speeds achieved historically and the Date the best / worst was achieved.

I initially tried Trellis but it does not give me a good result as I want to show 3 segments in each gauge that are relative to the speed of the machine.

I also want the user to be able to select the 12 machines to display (from a list of x machines)

My main data consists of

Machine

Date

Speed (Feeds per Hour)

I have also loaded a machine table 12 times (machine 1 to Machine 12) to allow the user to select each of the 12 machines.

I am struggling with Set Analysis.

The following statement returns a correct result if I have a Date selected to represent Today

=max({<[Machine]=[Machine1]>}[Feeds / Hour])

but if I then add 1 to ignore the current selection as below, I do not get a result.

=max({1<[Machine]=[Machine1]>}[Feeds / Hour])

can you stear me in the right direction.

Many thanks.

[jjfabian · Accepted solution]

Hi Tony,

how about

=max({<[Machine]=Machine1], Date= >}[Feeds / Hour])

if you want to ignore the Date for example

hope this helps,

Jakob

[#3]

Hi Jakob

You are a star!

Many thanks for your help. Works great.

=max({<[Machine]=[Machine1], Date= >}[Feeds / Hour])