Forum Discussion
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 Order > Inbound Shipment>Purchase Invoice
Regards
Jayanthan
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.
1 Reply
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.