Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

multiple information in one cell

Hello,

 

i need some idea how to handle multiple information in one cell 🙂 I have the follwing table and want to see the final result:

 

 

I need a Filter with the group entries and dynamic group column in the final matrix (see example where B is filtered).

 

I tried to create a separate table like

 

Measure_Selection =
DATATABLE (
"Measure",STRING,
"Order",INTEGER,
{
{ "A",1 },
{ "B",2 },
{ "C",3 }
}
)
 
but than it is not possible to use a measure as a column.
 
With
A = IF(ISBLANK(SEARCH("A", Table[Group], 1, BLANK())), BLANK(), "A")
it would be possible to extract A in a new column but didnt helped. 
 
many thanks for ideas.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Pikachu-Power ,

     

    You could create a table contains the split groups and use it as slicer.

    Then create a measure as below and filter the blank rows.

    Measure = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[group]),SELECTEDVALUE(slicer[group])),SELECTEDVALUE(slicer[group]),BLANK())

     

    Best Regards,

    Jay

4 Replies

    • Pikachu-Power's avatar
      Pikachu-Power
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

      hi amitchandak,

      you mean to split by a delimiter into columns and via pivot into rows? i was thinking about that but we would have to much rows than. with for example 100000 datasets and in avarage 3 group elements we would have 300000 datasets.

       

      Is it may possible to create additional columns via delimiter with only A, B or C entries and control these via the Measure_Selection Table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pikachu-Power ,

     

    You could create a table contains the split groups and use it as slicer.

    Then create a measure as below and filter the blank rows.

    Measure = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[group]),SELECTEDVALUE(slicer[group])),SELECTEDVALUE(slicer[group]),BLANK())

     

    Best Regards,

    Jay