Forum Discussion
Solved
filter on a text field
Hello, I have a simple table that includes a column named "purchunit." I want to iterate through the rows and determine if this field has a value of "LB" or "CS". I thought the following measure...
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! ❤️
Hi parry2K
Here is the column I created:
Here are the results of the formula. It always returns false.
Thank you
It appears that your solution does in fact work properly. I converted to upper and the following worked.
PriceUOM Column = if(upper(purchline[PurchUnit]) = "LB","true","false")
I will do some more testing and will flag as resolved.
thanks