Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Worked!
Never thought of using MAX for text field.
Thanks a lot.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |