Forum Discussion
Anonymous
6 years agoNot applicable
Measure based off columns shown? (screenshot example included)
Hi folks, So I figure this one is best explained with an example. In the attachment, the total revenue of Project 30000020 is $60k. However, since I've added EmployeeID, the one row expanded to...
parry2k
Super User
6 years agoAnonymous there are couple of ways to handle it, create a measure to divide revenue by each employee using measure, basically count the employee of the project and divide product amount by employee count and from there use this measure for all the calculations, or in power query get the total count of employees (similar approach as above) and distribute the amount. You have a few options to handle it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡