Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 :
Solved! Go to 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
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
@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
Proud to be a Super User! |
|
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |