Using Dax functions to create a mesure.

[Anonymous]

Hello,

I have this table that contains several groups. In the screenshot, I filtered only on a single group( GROUP 1)  to minimise the data. I wish I could create a measure, or a calculated column that returns for each group, the name of the class: the classes are A, B, C, D, E, F, G. They must always appear on the visual even if they are missing for some groups. In each class I have to display the names like the example I showed.

Any suggestion please? 

[amitchandak]

@Anonymous , while I did not get it completely. 

You need to have a separate table with distinct nom class 

Class  = distinct(Table[Nom Class]) 

Join this with this table  

I think you need a measure like  

measure = 

var _con = concatenatex(Table, Table[Nom]) 

return 

if(isblank(_con), "", _con) 

display with new table's column 

if not 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak  any suggestion please?