Matching several values in Set analysis

[georgina_spary]

Hello folks. I've written some set analysis. This counts students only where the [Module Compulsory Prog] field matches a single [Programme Code] field selected.

= Sum ({$<[Module Compulsory Prog]={$(=[Programme Code])}>}[Student Count])

How can I get it to work when I select multiple [Programme Code] fields - i.e count students where [Module Compulsory Prog] matches any of a selection of [Programme Code] fields?

Thanks in advance

George

[Anonymous · Accepted solution]

This should work, no matter if you select one or many:

= Sum ({$<[Module Compulsory Prog]=P([Programme Code])>}[Student Count])