Forum Discussion

Kukusiki83's avatar
Kukusiki83
Frequent Visitor
2 years ago
Solved

FILTER multiple tables

Hello, I need help!!!   I have a table - 'Calender' second table - 'sales' Third table - 'Tasks'   I want to calculate a distinct number of days (from the 'Calender') where: 'Sales'  - FILTER...
Need Help
  • Anonymous's avatar
    Anonymous
    2 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 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

Kukusiki83's avatar
Kukusiki83
Frequent Visitor
2 years ago

Hi, 

 

thanx for your reply. here's my tables and a wanted output

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 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 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