Ignore all fields from one table without Set Analysis

[t_donnet]

hi,

I've a condition to establish.

If one or more fields from a specific table is selected -> value A else value B.

I try to avoid all fields from a calendar table. Any way to ignore those fields without set analysis ?

[Vegar]

You can't really check if any field in a table is selected, but you can check for each field in the table using getSelectedCount() .

[Vegar]

You can't really check if any field in a table is selected, but you can check for each field in the table using getSelectedCount().

[t_donnet]

I was going to use getSelectedCount() and yes that's a good way for a few fields.

But how about more than 20 fields?

[jfkinspari]

You could create a variable, that loops over all fields in the calendar table and create the corresponding set analysis syntax, that you then can use in your measure

[sunny_talwar]

May be this is one of the options you can try

Ignore all selections except some specific fields using Set Analysis

[Vegar · Accepted solution]

You could do something like this to avoid listing the field values manually:

=if( 
   $(=concat({<[$Table] = {'MasterCalendar'}>}'getSelectedCount(['& $Field &'])', '+')) > 0, 
   'Value A (One or more calendar field is selected)', 
   'Value B (No Calendar field values are selected)'
)

[t_donnet]

That's what I'm looking for.

Thanks a lot @Vegar