Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 ...!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
3 | |
3 | |
2 | |
2 |