Forum Discussion
User Filtered Clients as filter
Hi all,
I need help with this.
I have a PowerBI Tab with client id table and some slicers(date, country, product...).
I want to filter clients table and use this clients to calculate some measures in other tab i.e. how many clients were existing clients before x time period and bought me product y....
I thought drillthrough would be useful for this but is not working because you can't drill with multiple clients.
Any support?
Thank you!
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create Calendar
DateTable = CALENDARAUTO()2. Create measure.
existing clients = var _min=MIN('DateTable'[date]) return CALCULATE(COUNT('Table'[ID]),FILTER('Table','Table'[date]<=_min&&'Table'[Buy]="YES" ))3. Result:
Use [Date] of the calendar table, [country] and [product] of the table as the slicer
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Anonymous , Yes, As of now you can not drill through with multiple values,
You can try sync slicer and navigation button
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create Calendar
DateTable = CALENDARAUTO()2. Create measure.
existing clients = var _min=MIN('DateTable'[date]) return CALCULATE(COUNT('Table'[ID]),FILTER('Table','Table'[date]<=_min&&'Table'[Buy]="YES" ))3. Result:
Use [Date] of the calendar table, [country] and [product] of the table as the slicer
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
