HELP! SUM by dates selected?

[alexwardeee]

Hi all,

I am doing some work regarding Desk Booking for my employer.

I have created a simpler dataset for the purpose of this but the issue i am having is i have a table that has the service areas and it's allocated desks. 

I have another table that has dates. When i select multiple dates i want it to sum the allocation but it doesn't seem to be doing anything as the service area table has no dates associated with it.

For example i have 1st & 2nd of January selected so i want the service areas to double because i have two dates selected - 

See below link for pbix file - https://www.dropbox.com/s/n8a28cit5bp836m/DeskBookingForum.pbix?dl=0

Any help would be appreciated.

[HotChilli]

I think I see what you want.  The Service Area Allocation field is a resource and you want to multiply those figures for the number of days selected in the slicer.

Change the slicer to be Date instead of DateHierarchy (from the down caret in the field well) because at the moment it is not reflecting the actual data .

Create two measures,

one: MeasureA to countrows in the Date table (straightforward enough),

two: MeasureB to multiply MeasureA by the SUM of the allocation.

Drag them both on to the table visual.  Select multiple dates in the slicer using CTRL

Let me know how it goes.