User Filtered Clients as filter

[Anonymous]

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!

[Anonymous · Accepted solution]

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

[amitchandak]

@Anonymous , Yes, As of now you can not drill through with multiple values,

You can try sync slicer and navigation button