ALL for Subtotals based on Slicer

[betsig250]

Hello..

I have 4 Categories that represented in a slicer. For each Category there are SubCategories. What I need to do is when a user clicks a category that I want a % of SubCategory Total Field. But when there is no slicer selected that field becomes a % of Grand Total.

I created a field called AllSales and it is the following at the moment..

AllSales:=if(ISFILTERED([Category]),XXXXX(WHERE I NEED THE HELP),CALCULATE([Sales],ALL(Data))

%ofSales:=DIVIDE([Sales],[AllSales],0)

I am trying to get AllSales to show the Category Total on each line when a user clicks on a category so then my %ofSales will work properly. I was thinking it should be something like..
CALCULATE([Sales],ALL(Data[Category]) but that just shows the subcategory dollar value.

Thanks

 

[betsig250]

I can get the answer if I drag Sales into the report again and set the Show Values As to % of Column Total. Would like to keep it in the same field tho.

Thanks!

 

[scottsen]

Clever Hierarchy Handling in DAX – SQLBI