While trying to answer a question in this forum I hit a problem.
How can I use a text field in a measure?
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.
Solved! Go to Solution.