Counting options in a Enum

[MauriceWhelan]

Hi.

Is there a way to count the possible values that exist in an Enum before the user selects any? (as per my screenshot below) I have tried with COUNT(SELECT(MHE_Comm_Fleet[Failed Check],[Record ID]=[_THISROW].[Record ID])) but i presume this expression requires a value to be stored first before it will return a value greater than 0.

Is there a way I can count before any values are selected?

Many thanks.

[Bahbus]

If your enum options are setup as such:

Then there is no way to count those, directly. Perhaps COUNT(UNIQUE(SELECT(MHE_Comm_Fleet[Failed Check], TRUE)))
would work assuming all options have been selected at least once.

Otherwise, your best bet would be to create a separate table to hold these options. Link to them via a VALID_IF instead of hardcoded in the column.

[MauriceWhelan]

Thankyou @Bahbus. I don’t have them hardcoded in but I think your suggestion of an alternative table storing the values might be best.