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];", "))
any ideas on combining values in 2 columns trough a measure.
Maybe something like sumx, countx, concatenatex? What exactly do you need?
Does the function VALUES work better than DISTINCT here?
hi thanks dude for your help.
It works perfectly into my cross table DAX
Awesome . It helped me. keep doing great work