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];”, “))

Now it is much better – each model only appears once.

5 Comments

  1. Maybe something like sumx, countx, concatenatex? What exactly do you need?

  2. hi thanks dude for your help.
    It works perfectly into my cross table DAX

Comments are closed.