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.
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.
Thankyou @Bahbus. I don’t have them hardcoded in but I think your suggestion of an alternative table storing the values might be best.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |