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...
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
Anonymous , Yes, As of now you can not drill through with multiple values,
You can try sync slicer and navigation button