Matrix Totals Incorrect

[Anonymous]

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?

[v-eqin-msft]

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

[amitchandak]

@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() ) )

[Anonymous · Accepted 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.