Using a text field in a DAX measure

[anandav]

Hi,

While trying to answer a question in this forum I hit a problem.

How can I use a text field in a measure?

e.g.

Dept   Employees

A           2

B           3

So how can I do:

Measure := IF('File'[Dept]="A", "This is dept A", "Not dept A")

I can do this for a column in a Dax new column or in M via Query Editor.

I understand in a measure there is no row context and need to use an aggregate function (for numeric fields) or calculate function.

But cannot figure out how the text field checking can be done in a measure.

[Phil_Seamark · Accepted solution]

Hi @anandav

Give this a try

Measure := IF( MAX('File'[Dept])="A", "This is dept A", "Not dept A")

[anandav]

Worked!

Never thought of using MAX for text field. 

Thanks a lot.