Alternate state and if statement

[alisonpwallis]

Hi,

I have a radar chart showing two groups - our organisation and the sector. The sector group can be divided into three categories and what I want to do is show on the chart label which group is being selected. I can do this with an if statement but the issue I'm having is that I have the sector data as an alternate state and I can't get the IF statement to work for the alternate state. Here is my statement:

=if([Inst/Inst Group]='Benchmark','Benchmark', if([Inst/Inst Group]='Competitor','UCAS competitor',if([Inst/Inst Group]='Other','Sector')))

Where do I put the alternate state in the syntax?

Thanks

Alison

[jerem1234 · Accepted solution]

Try this:

pick(match(only({State1}[Inst/Inst Group]), 'Benchmark', 'Competitor', 'Other'), 'Benchmark', 'UCAS competitor', 'Sector')

Hope this helps!

[alisonpwallis]

That's great - thank you!

Alison