Need help witth a matrix

[Krijgersss]

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 project. my time is calculate out 2 tables, project with WBS and projects without wbs. so the project list is wiht and without wbs. the measure i use for the time is this:

Uren project wbs medewerker =

COALESCE(

    SUM('public time_cost_transactions'[quantity]),

    SUM('public WBS_time_cost_transactions'[quantity])

)

if i want to go to my 3 level my employees i cant see any employees on a project without wbs, if the project have wbs (level 2) i can go 1 level down to employees but if the project doesnt have wbs i only see my project and i want to go down to level 3 employees. 

[v-kathullac]

Hi @Krijgersss  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @Krijgersss  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @Krijgersss  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[Anonymous]

Hi @Krijgersss ,

Thanks for bhanu_gautam's reply!
You have multiple tables involved here. I cannot create sample data for testing myself. It is almost impossible to find a solution based on this information alone. Please provide sample data of all tables involved and the relationship between the tables, as well as your expected results so that we can better understand your needs. Thank you!
Re: How to Get Your Question Answered Quickly - Page 2 - Microsoft Fabric Community

Best Regards,
Dino Tao

[bhanu_gautam]

@Krijgersss , 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]
)

[Krijgersss]

Still 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