Forum Discussion
Solved
Remove Duplicate Values using CONCATENATEX and Direct Query
I am having trouble getting values from a Direct Query to appear correctly in a table using the CONCATENATEX fxn. I have tried multiple fxn setups and all present varying issues. Each row corresponds...
Dangar332 I figured out the issue. It had something to do with the ordering of the relations to tables in the Model View - I shortened the path and it started working correctly using the following DAX:
List of BMP observations =VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT(FindingsFacilityVisualList[bmpObs])RETURNCONCATENATEX(DISTINCT(FILTER(FindingsFacilityVisualList,FindingsFacilityVisualList[bmpObs] <> BLANK())),FindingsFacilityVisualList[bmpObs],", ")
Hi, HoppeG76
try below measure
just adjust your table and column name
i am taking some different but end goal is same as you want
Measure 4 =
CONCATENATEX(
FILTER(
ALL('Table (5)'[Column1]),
'Table (5)'[Column1]<>BLANK()
),
'Table (5)'[Column1], ", "
)
Dangar332 Thank you for your response, unfortunately this provides the same result as the third method in my post.
Results in incorrect values:ID#1 - value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6ID#2 - value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6ID#3 - value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6ID#4 - value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6ID#5 - value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6, value1, value2, value3, value4, value5, value6*ID#4 & #5 should not have values associated with them** I edited my original post for additional clarity about how my data values differ