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
I have written the IF condition and values are coming with duplicate record then on top that I have one more column for Concatenate (comma) seperated but it showing multiple repeated values but it suppose to show unique values.
Expecting result should be like Col Name: Values(A1, A2, A3..) without repeating again same value.
Ex:
Dax Function I have written
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You can update the formula of measure [Concatenated Bu Org Final] as below:
Concatenated Bu Org Final =
CONCATENATEX (
GROUPBY (
'Opportunities',
'Opportunities'[Vertical Market],
Opportunities[Bu Org Final]
),
Opportunities[Bu Org Final],
"; "
)
Best Regards
Hi @Anonymous ,
You can update the formula of measure [Concatenated Bu Org Final] as below:
Concatenated Bu Org Final =
CONCATENATEX (
GROUPBY (
'Opportunities',
'Opportunities'[Vertical Market],
Opportunities[Bu Org Final]
),
Opportunities[Bu Org Final],
"; "
)
Best Regards
Thanks for your help.. Its near about the solution ...!!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
3 |