Forum Discussion
filter on a text field
MJBLACK when you add a column it is always in the row context, so add a column, and don't use any aggregate function, did you try what I provided?
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
MJBLACK I would recommend using PQ to add a new column but if you want to use DAX for whatever reason then do this:
PriceUOM Column =
IF ( purchLine[PurchUnit] = "LB", "true", "false" )
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Hello,
If this is a column, how does DAX know what the row context is? It appears to yield the same result as what I tried to do.
Thanks