Forum Discussion
Solved
Finding related subtotals
I have this issue where I cannot find the related subtotals. I have a datasource with these three tables, with simplified contents here: Project-Sales - Project-ID - Invoice-value Project-...
As per your logic, I think it is simple to solve your problem per below measure,
Subtotal for Each =sumx('Project-Member',related('Project-Sales'[Invoice-value]))Let me know if it works.
Thank You for your extensive reply. However the result calculation you suggest is not correct.
In Your example, person 1001 is a member of project ID 1, 3 and 4. Sum of sales for those project is 10+30+40=80, not 60 as your calculation shows.
I don't know if there is an misunderstanding. I just want to get the summaries for the projects for each person involved, I don't understand why I would want to count rows or make average calculations?
Please I'm happy for your continued help! 🙂
TonyZhou1980
Resolver I
Resolver IAs per your logic, I think it is simple to solve your problem per below measure,
Subtotal for Each =
sumx(
'Project-Member',
related('Project-Sales'[Invoice-value])
)
Let me know if it works.
This was so much easier solution, thank You very much, works perfect! 🙂