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

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

     

     So for every month and every customer the formula needs to check if there is at least one invoice with a "premium" module.

     

    Thanks for your help already.

     

    YearPeriodeRelatienaamInvoicenumberModuleDesired outcome
    20181Client 113-104223Standard module 1Premium client
    20181Client 113-104223Premium module 2Premium client
    20181Client 113-104223Premium module 1Premium client
    20181Client 113-104223Standard module 2Premium client
    20181Client 113-104292Extra modulePremium client
    20181Client 113-104292Standard module 2Premium client
    20181Client 113-104368Standard module 1Premium client
    20181Client 113-104368Premium module 2Premium client
    20181Client 113-104368Premium module 1Premium client
    20181Client 113-104368Standard module 2Premium client
    20181Client 213-104223Standard module 1Standard client
    20181Client 213-104223Standard module 2Standard client
    20181Client 213-104292Extra moduleStandard client
    20181Client 213-104292Standard module 2Standard client
    20181Client 213-104368Standard module 1Standard client
    20181Client 213-104368Standard module 2Standard client
    20181Client 113-104223Standard module 1Premium client
    20181Client 113-104223Premium module 2Premium client
    20181Client 113-104223Premium module 1Premium client
    20181Client 113-104223Standard module 2Premium client
    20181Client 113-104292Extra modulePremium client
    20181Client 113-104292Standard module 2Premium client
    20181Client 113-104368Standard module 1Premium client
    20181Client 113-104368Premium module 2Premium client
    20181Client 113-104368Premium module 1Premium client
    20181Client 113-104368Standard module 2Premium client
    20181Client 213-104223Standard module 1Premium client
    20181Client 213-104223Standard module 2Premium client
    20181Client 213-104292Extra modulePremium client
    20181Client 213-104292Standard module 2Premium client
    20181Client 213-104368Standard module 1Premium client
  • Hidde's avatar
    Hidde
    Icon for Helper I rankHelper I
    8 years ago
    YearPeriodCustomer_nameInvoicenumberModuleDesired outcome
    20181Client 113-104223Standard module 1Premium client
    20181Client 113-104223Premium module 2Premium client
    20181Client 113-104223Premium module 1Premium client
    20181Client 113-104223Standard module 2Premium client
    20181Client 113-104292Extra modulePremium client
    20181Client 113-104292Standard module 2Premium client
    20181Client 113-104368Standard module 1Premium client
    20181Client 113-104368Premium module 2Premium client
    20181Client 113-104368Premium module 1Premium client
    20181Client 113-104368Standard module 2Premium client
    20181Client 213-104223Standard module 1Standard client
    20181Client 213-104223Standard module 2Standard client
    20181Client 213-104292Extra moduleStandard client
    20181Client 213-104292Standard module 2Standard client
    20181Client 213-104368Standard module 1Standard client
    20181Client 213-104368Standard module 2Standard client
    20182Client 113-104223Standard module 1Premium client
    20182Client 113-104223Premium module 2Premium client
    20182Client 113-104223Premium module 1Premium client
    20182Client 113-104223Standard module 2Premium client
    20182Client 113-104292Extra modulePremium client
    20182Client 113-104292Standard module 2Premium client
    20182Client 113-104368Standard module 1Premium client
    20182Client 113-104368Premium module 2Premium client
    20182Client 113-104368Premium module 1Premium client
    20182Client 113-104368Standard module 2Premium client
    20182Client 213-104223Standard module 1Premium client
    20182Client 213-104223Standard module 2Premium client
    20182Client 213-104292Extra modulePremium client
    20182Client 213-104292Standard module 2Premium client
    20182Client 213-104368Standard module 1Premium client
    20182Client 213-104368Premium module 2Premium client
  • Hidde's avatar
    Hidde
    Icon for Helper I rankHelper I
    8 years ago
    YearPeriodCustomer_nameInvoicenumberModuleDesired outcome
    20181Client 113-104223Standard module 1Premium client
    20181Client 113-104223Premium module 2Premium client
    20181Client 113-104223Premium module 1Premium client
    20181Client 113-104223Standard module 2Premium client
    20181Client 113-104292Extra modulePremium client
    20181Client 113-104292Standard module 2Premium client
    20181Client 113-104368Standard module 1Premium client
    20181Client 113-104368Premium module 2Premium client
    20181Client 113-104368Premium module 1Premium client
    20181Client 113-104368Standard module 2Premium client
    20181Client 213-104223Standard module 1Standard client
    20181Client 213-104223Standard module 2Standard client
    20181Client 213-104292Extra moduleStandard client
    20181Client 213-104292Standard module 2Standard client
    20181Client 213-104368Standard module 1Standard client
    20181Client 213-104368Standard module 2Standard client
    20182Client 113-104223Standard module 1Premium client
    20182Client 113-104223Premium module 2Premium client
    20182Client 113-104223Premium module 1Premium client
    20182Client 113-104223Standard module 2Premium client
    20182Client 113-104292Extra modulePremium client
    20182Client 113-104292Standard module 2Premium client
    20182Client 113-104368Standard module 1Premium client
    20182Client 113-104368Premium module 2Premium client
    20182Client 113-104368Premium module 1Premium client
    20182Client 113-104368Standard module 2Premium client
    20182Client 213-104223Standard module 1Premium client
    20182Client 213-104223Standard module 2Premium client
    20182Client 213-104292Extra modulePremium client
    20182Client 213-104292Standard module 2Premium client
    20182Client 213-104368Standard module 1Premium client
    20182Client 213-104368Premium module 2Premium client
    • 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())