Forum Discussion
Solved
Dax formula returning duplicate items
Hey there! Hoping I get some help with a measure I am working on. My ultimate goal is to get a concatenated list of contacts returned based on the data uploaded to a particular report. Gett...
Hi,
I created this calculated column formula in the Data Table
Contact = related(Contacts[Contact])
and then wrote this measure
Measure = CONCATENATEX(VALUES(Data[Contact]),Data[Contact],", ")
Sure!
Data Table ex:
| Ship ID | Lane |
| 1 | AR_CA |
| 2 | CA_CA |
| 3 | ME_AR |
| 4 | AR_CA |
| 5 | ME_CA |
SCAC Assignments ex:
| Lane | Scac |
| AR_CA | ABCD |
| CA_CA | EFGH |
| ME_AR | IJKL |
| AR_OK | MNOP |
| ME_CA | QRST |
Contacts ex:
| Scac | Contact |
| ABCD | [email protected] |
| EFGH | [email protected] |
| IJKL | [email protected] |
| MNOP | [email protected] |
| QRST | [email protected] |
Sample return data:
| Desired Result: |
| [email protected];[email protected];[email protected];[email protected] |
No duplicates, only includes applicable contacts for lanes provided.
Let me know if there's anything else I can provide!
Hi,
I created this calculated column formula in the Data Table
Contact = related(Contacts[Contact])
and then wrote this measure
Measure = CONCATENATEX(VALUES(Data[Contact]),Data[Contact],", ")