Forum Discussion
FILTER multiple tables
- Anonymous2 years ago
Hi Kukusiki83 ,
Does the model look like this?
Try this measure and tell me the result.Measure = CALCULATE ( DISTINCTCOUNT ( Calendar[Date] ), FILTER ( SALES, SALES[Appels IN] > 1 && SALES[email2] = [CurrentUser] ), CROSSFILTER ( Calendar[Date], Sales[Date], BOTH ), FILTER ( Task, Task[email2] = [CurrentUser] && Task[hour] < 20 && Task[ALL TASK] >= 1 ), CROSSFILTER ( Calendar[Date], 'Task'[Date], BOTH ) )Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Hi,
thanx for your reply. here's my tables and a wanted output
Hi Kukusiki83 ,
Does the model look like this?
Try this measure and tell me the result.
Measure =
CALCULATE (
DISTINCTCOUNT ( Calendar[Date] ),
FILTER ( SALES, SALES[Appels IN] > 1 && SALES[email2] = [CurrentUser] ),
CROSSFILTER ( Calendar[Date], Sales[Date], BOTH ),
FILTER (
Task,
Task[email2] = [CurrentUser]
&& Task[hour] < 20
&& Task[ALL TASK] >= 1
),
CROSSFILTER ( Calendar[Date], 'Task'[Date], BOTH )
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group