Forum Discussion
AdministratorFilter by text column by customer
Hello
of a table with customer records, I want to show only customers that don't have the text "seg_client" in the Interaction Template column
Attached is a screenshot of how the table is.
It's a log table so there will be a lot of lines where the customer repeats because it's recording customer data. So, a client can have a line with "p_marcha" but not have another line with "seg_client", which would be what I'd want to get out.
Only if a customer has a line with "seg_cliente" would already be discarded.
Thank you.
4 Replies
- amitchandak
Super User
Create measure like
M1= calculate(countrows(Table), Filter(all(Table), Table[Customer] = max(Table[Csutomer]) && [ Interaction Template column] = "SEG_CLIENT") )
Not have Seg Client = countx(Values(Table[Customer]) , if(isblank([M1]), [Customer], blank()) )
Syndicate_AdminIt works well for me, now, following the same thing, I could use another measure but that does the following:
- Based on what you put in the relative date filter, show me the customers who haven't had SEG_CLIENT in the last month
* I've put last month since the catch puts it like that but it could be anything, two months, 1 day..Thank you.
- Syndicate_Admin
Hello
I don't understand the measurements very well but I have tried to reproduce them and the first one, M1 gives me a blank result, then the second one gives me 8, which is the number of SEG_CLIENT there are.
With the first measure, I don't know what you get, but the final result should be for customers who don't have a line with SEG_CLIENT.
- Syndicate_Admin
I think it's going well now. I'll check it out and tell you. Although I still don't understand the M1 measure
Thank you.
