Forum Discussion

jayanthan's avatar
jayanthan
Helper III
7 years ago
Solved

Contains

Hi there   I have column with below values. I want filter only values which has the word "Inbound". How can i do it , please advise   Purchase Order Purchase Order > Inbound shipment Purchase O...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi jayanthan 

    Please see below two possible solutions.

    Measure = 
CALCULATE(
    COUNTROWS(YourTable), -- your expression or measure
    IFERROR(SEARCH("Inbound", YourTable[Column1]), 0) > 0
)
    Column = IFERROR( SEARCH( "Inbound", YourTable[Column1] ), 0 ) > 0

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi jayanthan 

Please see below two possible solutions.

Measure = 
CALCULATE(
    COUNTROWS(YourTable), -- your expression or measure
    IFERROR(SEARCH("Inbound", YourTable[Column1]), 0) > 0
)
Column = IFERROR( SEARCH( "Inbound", YourTable[Column1] ), 0 ) > 0

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.