Forum Discussion
MAX function with Text column doesn't work in Live Connection SSAS Tabular
Hi Experts, I have a trouble using DAX function: MAX. I want to get a unique value from Text column to use switch to use different calculation for each category in one measure. In Power BI D...
the way you wrote it, you perhaps tried to do this instead
e.g. Measure = IF(MAX('Table'[TextColumn]) = "A", Value, Blank())
there was an extra ")"
don't know if it helps
I'm sorry I put wrong express in my post, I surely used correct expression that works in Power BI without SSAS.
like you corrected.
e.g. Measure = IF(MAX('Table'[TextColumn]) = "A", Value, Blank())
Therefore, the error is not from ")"
Thanks.