Forum Discussion
Krijgersss
Helper II
Helper IINeed help witth a matrix
hello i need some help with the hierachy of my matrix. i have a matrix with 3 levels: Project wbs employee and i have a measure for the time so you can see how many time someone workt on a ...
bhanu_gautam
Super User
Super UserKrijgersss , Try using
DAX
Uren project wbs medewerker =
SUMX(
UNION(
SELECTCOLUMNS(
'public time_cost_transactions',
"Project", 'public time_cost_transactions'[Project],
"WBS", BLANK(),
"Employee", 'public time_cost_transactions'[Employee],
"Quantity", 'public time_cost_transactions'[quantity]
),
SELECTCOLUMNS(
'public WBS_time_cost_transactions',
"Project", 'public WBS_time_cost_transactions'[Project],
"WBS", 'public WBS_time_cost_transactions'[WBS],
"Employee", 'public WBS_time_cost_transactions'[Employee],
"Quantity", 'public WBS_time_cost_transactions'[quantity]
)
),
[Quantity]
)
KrijgersssHelper II
Helper IIStill dont work for me by projects that dont have a level 2 i cant seee my level 3 it only shows me my level 1