Forum Discussion
Helper IAverage with two fact tables
Super Usermscabrera , You can try like
Calculate([Avg Meausre], filter( VW1, VW1[Code] in Values(VW1[Code]) )
You can also use treatas in place of filter
Helper IHey amitchandak , thank you for your response.
Unfortunatly the code yo provided doesn't work as expected, in fact, gives the exact same result of the avg hours measure that I have
is not dividing the sum hrs into the total number of codes, that for this case is 6.
The issue is that for that specific project type should be 6 but there are other project types as shown in following table
and I understand it might be related to the context transition, but at the end, I need to use the average measure to compute another total not grouped by task, but by project type and role:
The first table calcualte the average by task and role to provide a sum of hours logged by task and role
Hope you can help with it
Regards