Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am using Measures to get FTE requirement on Projects based on Resource Capacity and Demand. Two different tables that is linked with Resource table and time set.
When I select the indidividual resource I get the correct totals, but when I select all resources by projects, the totals are different - it is less and incorrect.:
Individual resource
The person who is demanded 100% is now down to 0.01. Is there more to this?
Solved! Go to Solution.
Thanks for your response.
I ended up using M in Power query to get the results I wanted instead of DAX. Deleted all the DAX.
Thanks again.
Hi @Anonymous ,
It seems that your issue has been resolved by yourself. Could you please share the workaround and then kindly Accept it as the solution ? So that more people will benefit from it.
Thanks in advanced!😀
Best Regards,
Eyelyn Qin
@Anonymous , How you can calculate this
if you are using like
measure = divide([measure], calculate([measure], all() ) )
then you need
measure = divide([measure], calculate([measure], allselected() ) )
Thanks for your response.
I ended up using M in Power query to get the results I wanted instead of DAX. Deleted all the DAX.
Thanks again.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |