Contains

[jayanthan]

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 Order > Inbound Shipment>Purchase Invoice 

Regards

Jayanthan

[Mariusz · Accepted solution]

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.