Percent of Total with Grouping

[aellison]

I have a calculation that I am having issues with. I want to create a stacked column chart where the total height is the overall groups percentage, but the stacks are a subset of those groups. Here is a mock example of the dataset

ID	Department	NumDays	Scheduled	DaysGroup
111	PEDIATRIC	3	1	0-7 Days
222	PEDIATRIC		0	Open
333	PEDIATRIC	20	1	8-21 Days
444	SURGERY	11	1	8-21 Days
555	SURGERY	15	1	8-21 Days

I want to show the bars in the chart by Department, and the stacks by DaysGroup. The bars respresent a percentage of the Scheduled vs All Rows. They should only use a calculation based on their respective department. As seen below, the example shows 3 tables, the numerators being used, the denominators being used, and the current calculation. The arrows show the various numbers that I am trying to use:

Link in case the image is not legible:  Link for Report Example

 

Any help is greatly appreciated.

[Vvelarde · Accepted solution]

hi @aellison

Try with this:

%Scheduled = [SumScheduled]/CALCULATE([CountId],ALLEXCEPT(Table1,Table1[Department]))

[aellison]

Thank  you @Vvelarde .. that worked great ...