Forum Discussion

taher's avatar
taher
Helper II
9 years ago
Solved

concatenate Values repeatly

Hi All,   as you can see in the photo, I have a table of two columns. StoreId: every value is repeated three times because every value has three TagId. I'm trying to create a new column which con...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    taher

     

    Hi Taher,

     

    If you want it in DAX, you could try these two options.

    Option 1: there will be duplicate rows.

     

    New =
CALCULATE (
    CONCATENATEX ( 'Table1', 'Table1'[TagId], "-" ),
    FILTER ( 'Table1', 'Table1'[StoreId] = EARLIER ( Table1[StoreId] ) )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Option 2: create a new table.

     

    Table =
SUMMARIZE (
    'Table1',
    'Table1'[StoreId],
    "NewColumn", CONCATENATEX ( 'Table1', 'Table1'[TagId], "-" )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

taher's avatar
taher
Helper II
9 years ago

Hello v-jiascu-msft,

 

hier you find a full sample project.

ParentTagID = 150  =>Boss

ParentTagID = 140  =>Worker

ParentTagID = 130  =>Student.

 

https://www.4shared.com/s/fWHB5XsRDei

 

as you can see when I filter due to StoreName, the three  Boss, worker and the student are appearing in the three slicers.

It should just on of them for each slicer according to its PaentTagID.

 

Thanks a lot :)

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi taher,

 

I can't download the file from your URL. The download button didn't work. Could you please use GoogleDrive or OneDrive?

 

Best Regards

Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    taher

     

    Hi Taher,

     

    First, I would recommend a custom slicer.

    Add a calculated column first in the table "tags".

     

    PName =
IF (
    [ParentTagID] = 130,
    "Student",
    IF ( [ParentTagID] = 140, "Worker", IF ( [ParentTagID] = 150, "Boss", "Null" ) )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Second, due to the measure can be put in a slicer, we have to filter these data to a new table.

     

    130 =
FILTER ( 'Tags', 'Tags'[ParentTagID] = 130 )
    140 =
FILTER ( 'Tags', 'Tags'[ParentTagID] = 140 )
    150 =
FILTER ( 'Tags', 'Tags'[ParentTagID] = 150 )

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

  • taher's avatar
    taher
    Helper II
    9 years ago

    hello v-jiascu-msft,

     

    we still have the same Problem.

    when I for Example filter according to the worker 'Mark', it filters all the Bosses and the Students! But 'Mark' must filter just the ones who ist not in a pair with him in the original table ( Mark has John as a Boss and Andre as a student) these but disappeared too.

    It is really difficult, I'v just tried and tried but it would not work.

     

    Best,

    Taher