how to remove duplicate values in a measure

[Vaishali04]

Hi All,

I have below measures  . There can be mutiple products selected and for multiple products there can be same contact or different contact. When the measures claculates , it list down the all rows for the selected products . so that may result in listing same contact multiple times.

CONCATENATEX(

    productemail,

   productemail[product_contact],

    "; ",

    productemail[product_id]

)

How to list unique contacts in above measure. It can't be calculated in power query becz product selections are dynamic at UI in filter,

Please help

Regards

Vaishali

[rajendraongole1]

Hi @Vaishali04 -Create a below dax measure to get the unique contacts based on selected product.

UniqueContacts =
CONCATENATEX(
DISTINCT(productemail[product_contact]),
productemail[product_contact],
"; "
)

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Vaishali04]

getting error when multiple values are there