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

 

I want to check whether in the current month a customer has at least one premium module. IF so, then the client is a premium client this month. So I need the check this for every client in one month.

 

I am a bit stuck because dynamic segmentation only looks at numbers, not at text. Could anyone give a hint?

  • 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())

7 Replies

  • 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