Forum Discussion

MJBLACK's avatar
MJBLACK
New Member
3 years ago
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...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    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! ❤️

parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

MJBLACK sounds good. 

 

👉 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! ❤️