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

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.

 

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Arminx

 

If you have got your problem solved, you could mark the right answer to close this thread. :smileyhappy:

 

Best Regards,

Herbert