topic if text contains DAX in DAX Commands and Tips

if text contains DAX

Anonymous — Thu, 25 Jan 2024 15:49:18 GMT

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

Re: if text contains DAX

bhanu_gautam — Thu, 25 Jan 2024 16:39:27 GMT

Anonymous , 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

Re: if text contains DAX

Anonymous — Fri, 26 Jan 2024 09:22:29 GMT

Hi, Anonymous

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é] )

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