Skip to Content
0
Jan 18 at 09:28 AM

How to create a variable that lists custom Strings?

162 Views Last edit Jan 18 at 02:30 PM 2 rev

Hi there, I'm trying to create a custom list of Strings like 'Full Group' and 'Kleihauer Test' that I can then Direct a custom measures to list next too like so:

Image preview

Basically my measure would read =(If [Custom List] = "CGS" Then ((Sum ([Test Code]="AA")) - (Sum([Test Code]="A"))), but I don't know how to/if you can create a variable that just list custom Strings

Thanks

Adam