CONCATENATEX providing unique (distinct) values
The CONCATENATEX function concatenates texts in measures / in visuals. But how to use it to show unique values?
Let´s have the table with cars, containing Brand and Model.
We need to know, which model of which brand is there.
If we simply used CONCATENATEX to create a measure and if we used this measure in a matrix, we would see this:
- List of models = CONCATENATEX('table';'table'[Model];", ")
Models (like Spider) are not unique. So let´s modify the formula this way:
- List of unique values = CALCULATE(CONCATENATEX(DISTINCT('table'[Model]);'table'[Model];", "))