Creating a measure to calculate percentage of total that updates with slicer selection

[bbalch]

I bet there is a simple formula for this, but I'm new to power pivot and DAX and I can't get this to work how I would like. I created a power pivot table with the Row Label "Activity" and the values "Activity Total" and "Activity Count". Activity total is the dollars associated with the Activity row label. The pivot table also has three slicers: Fiscal Year, Department, and Event.

I'm trying to create two measures to add to the pivot table that will update based on the slicer selections:
- Activity Percentage = activity total / activity total grand total
- Activity Count Percentage = Count by Activity / Count by Activity Grand Total

Here is a dropbox link to the file I'm working on.

https://www.dropbox.com/s/evzwe1regsod3az/T&E.xlsx?dl=0

Any help you can give me is greatly appreciated.

Thanks,
Ben

 

[theBardd]

Your DropBox link is erroring Ben.

 

[scottsen]

certainly *sounds* straight forward, but indeed... broken dropbox link.