Forum Replies Created
-
AuthorPosts
-
November 13, 2018 at 12:30 am in reply to: How to use a measure in another table with many to many relationship #11214
Apologies – I misunderstood what was happening!
After further investigation I can see that the tblResource is being filtered by the date. It is not being filtered by [Booking Group]. Ive now tried using the following:
=sum(tblTasksSimple[Effort])*calculate([ActualAvailableResource],tblResource[Booking Group]) without success.
and [ActualAvailableResource]=sumx(tblResource,tblResource[Available Hrs]*RELATED(tblCalendar[Daily % of Annual]))
Hope this helps.
Regards
Peter
Hi Tom,
Firstly, your assumptions are all spot-on and apologies for the error in SumofEffort.
Secondly, your answer works perfectly for which I’m really grateful – I have been struggling with this for weeks and have been learning Powerpivot at the same time! Its a really useful tool, but quite a different way of thinking from my previous approach without the ‘Power’ tools.
Again, many thanks – the help is very much appreciated.
Regards
Peter
-
AuthorPosts