Forum Discussion

Hidde's avatar
Hidde
Icon for Helper I rankHelper I
8 years ago
Solved

Creating segments of customers based on multiple rows & values

Hi,   I have rows of invoices, so lets say for 1 customer there are 4 invoices with a text description:   1. Standard module 1 2. Premium module 1 3. Standard module 2 4. Premium module 2   ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Hidde,

     

    You can use below measure to check premium status.

     

    Is premium =
SEARCH (
    "Premium",
    CONCATENATEX ( ALLSELECTED ( Table1[Module] ), [Module], "," ),
    1,
    0
)
    > 0

     

    Regards,

    Xiaoxin Sheng

  • Hidde's avatar
    Hidde
    8 years ago

    Thanks I managed to solve it this way:

     

    if(search("Premium",Table1[Modules],,0)>0,,1,,blank())

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Hidde,

 

Can you please share some sample data? I'm not so clarify for your data structure.

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Hidde,

     

    You can use below measure to check premium status.

     

    Is premium =
SEARCH (
    "Premium",
    CONCATENATEX ( ALLSELECTED ( Table1[Module] ), [Module], "," ),
    1,
    0
)
    > 0

     

    Regards,

    Xiaoxin Sheng

    • Hidde's avatar
      Hidde
      Icon for Helper I rankHelper I
      8 years ago

      Thanks I managed to solve it this way:

       

      if(search("Premium",Table1[Modules],,0)>0,,1,,blank())