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.


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

Leave a Reply

Your email address will not be published.


clear formPost comment