Forum Discussion
summarize Employee result by Project
Danny-Happy there are many ways to solve it, try this measure:
Total Rev = SUMX ( SUMMARIZE ( Table, Table[Name], Table[Project], "@Revenue", SUM ( Table[Revenue] ) * MAX ( Table[Percentage] ) ), [@Revenue] )Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Danny-Happy there are many ways to solve it, try this measure:
Total Rev =
SUMX (
SUMMARIZE (
Table,
Table[Name],
Table[Project],
"@Revenue", SUM ( Table[Revenue] ) * MAX ( Table[Percentage] )
), [@Revenue]
)
Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thanks for your answer. Is there something I am doing wrong? Becasuse is does not work.
FYI the first name in table 2 = project name and the second = employee name:
BTW: This is my model: