if text contains DAX

[LD1]

Hi everyone, 

In my research i saw different formulas but none of them match with mine.

Here, you can see what I tri to figure it out : 

Measure = IF( CONTAINS('Origine de vente retraitée','Origine de vente retraitée'[Pole/Zone retraité],"ZONE"), "DCL",'Origine de vente retraitée'[Pole/Zone retraité] )

Data type : Text (?)

Please, can you help me to solve this issue ? 

Thank you so much in advance !

Have a good day

[Anonymous · Accepted solution]

Hi, @LD1 

You can try the measure to solve the problem. If it doesn't work, you can check if the solution linked below meets your needs.

Measure:

Measure = IF(
    SEARCH("ZONE", 'Origine de vente retraitée'[Pole/Zone retraité], 1, BLANK()) <> BLANK(),
    "DCL",
    'Origine de vente retraitée'[Pole/Zone retraité]
)

Related link: Solved: DAX If field contains text - Microsoft Fabric Community 

If this does not work, could you please share some sample data without sensitive information and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[bhanu_gautam]

@LD1 , Please try this one 

Measure =
IF (
CONTAINS (
VALUES ('Origine de vente retraitée'[Pole/Zone retraité]),
'Origine de vente retraitée'[Pole/Zone retraité],
"ZONE"
),
"DCL",
'Origine de vente retraitée'[Pole/Zone retraité]
)

Please accept as solution and give kudos if it helps