Forum Discussion

Musashi01's avatar
Musashi01
New Member
4 years ago

Selecting data excluded from slicer filter

Each one of our projects and staff members are allocated to a (single) cost centre (say 01, 02 and 03) and region (A, B and C).  Any person can book time to any project, irrespective of region or cos...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Musashi01 , Create an independent Table with Employee cost center

 

cost center = distinct(Table[Employee cost center])

 

then create a measure like

Measure =

var _tab = summarize(Filter(Table, Table[Employee cost center] in allselected('cost center'[Employee cost center])), Table[Project region])

return 

calculate(sum(Table[Cost]), filter( Table, Table[Project region] in _tab) )