Forum Discussion

Arminx's avatar
Arminx
Frequent Visitor
9 years ago
Solved

Use filter but avoid propoagation effect

Hola,    I'm trying to calculate how much an employee is spending time on actual projects: 'productivity' = [total hours worked on projects] / [total hours that the employee was available] I'm ...
  • Arminx's avatar
    Arminx
    9 years ago

    I created a new AllDates(id, date) table with 1:* relationship with Tornado and 'public employee_schedule' on date column.

    In my page, I use AllDates.date for filtering, which propagates to both Tornado and public 'public employee_schedule'.

     

    Finally I use Format > Edit Interactions to avoid any other unwanted filters/slicers affecting my measure (that is shown in a KPI card).

     

    Thanks guys for the help.

     

Arminx's avatar
Arminx
Frequent Visitor
9 years ago

DB Schema. 'Tornado' is the table that records hours spent. employee_schedule is the table that records available hours per day per employee.

 

 

LaurentCouartou's avatar
LaurentCouartou
Solution Supplier
9 years ago

From what I can see, filters on the Tornado table do not propagate to the 'public employee' table. However, they propagate to the 'public project' table.

Is there any chance 'public project' indirectly filters the 'public employee_schedule'? This might be the cause of the observed behavior.

 

Anyway, taking the DAX route, you can try someting along the line:

TotalAvailableHours:=CALCULATE(
        SUM( 'public employee_schedule'[hours])
        , ALL(Tornado)
)