Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using Dax functions to create a mesure.

 

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? 

 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.