Like Statement for Master Measure

[jerryr125]

Hi - I am trying to create either a variable or master measure.

Basically I would like to do the following :

- I have a text field in my table named  AdditionalTopics

-  say my table consists of 150+ records

- I would like a sum of all of the records in which the word 'student' is within the text field  AdditionalTopics

- I tried the below as a master measure and created a KPI - no luck

Master measure: Internship

Expression:

=If(AdditionalTopics like 'student*',1,0)

No luck - any thoughts ?

Thanks - jerry

[OmarBenSalem]

try:

count(distinct {<AdditionalTopics={"*student*"}>} AdditionalTopics)

Then, u can create this as a master measure and use it

or create a variable as follow:

vStudent = AdditionalTopics={"*student*"}

and use this expression:

count(distinct {<$(vStudent)>} AdditionalTopics)