Forum Discussion

Marco_Natuzzi's avatar
Marco_Natuzzi
Frequent Visitor
3 years ago

Merge Different some Distinct Values in a column by only using a new measure (or tother tips)

Hi guys I need some support - I am operating with Power BI on Tabular cube. Consider that I cannot create new tables or access the Transform Data section, I can only create new measures.

My problem is as follows -> I have a table defined as "Dim_Saltotti", inside the column "Piattaforma Commerciale" I have the following values:

I would like to make a merge of the entries "CLOSED BASE HIGH BACK", "CLOSED BASE LOW BACK", "OPEN BASE METAL FEET HIGH BACK", "OPEN BASE METAL FEET LOW BACK", "OPEN BASE WOODEN FEET LOW BACK" and "OPEN BASE WOODEN FEET HIGH BACK"; and at the same time leave the entries "CUSHIONS", "OCCASIONAL CHAIR", "POUF", "RECLINER" and "REVIVE".

Do you know if I can achieve this through the creation of a new measure ? If not possible do you know how I can create new tables or new columns despite operating on a tabular cube ?

Thank you for any answer
Marco

Need Help

2 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    3 years ago

    Marco_Natuzzi ,

    try this measure,

    Concatenate values = 
VAR _temTable = FILTER('Dim_Saltotti',
                                'Dim_Saltotti'[PiattaformaCommerciale]<>"CUSHINI" &&
                                'Dim_Saltotti'[PiattaformaCommerciale]<>"OCCASIONAL CHAIR" &&
                                 'Dim_Saltotti'[PiattaformaCommerciale]<>"POUF" &&
                                 'Dim_Saltotti'[PiattaformaCommerciale]<>"RECLINER" &&
                                 'Dim_Saltotti'[PiattaformaCommerciale]<>"Revive")
VAR _result = CONCATENATEX(_temTable,'Dim_Saltotti'[PiattaformaCommerciale],UNICHAR(10))
RETURN _result

    Thanks,

    Arul

    • Marco_Natuzzi's avatar
      Marco_Natuzzi
      Frequent Visitor
      3 years ago

      Hi Arul, first of all thank you very much for your answer, I wanted to specify the question I asked better, my goal is to go from the "as is" situation to the "to be" situation through a "new measure". I make a graphic representation that can make better understand concept