Percentage in a Matrix with hierarchies totalling 100% down a column

[DebbieE]

I have the following issue

From Dim Date 'Year and Month' in Columns 

Values % People

And in Rows I have 5 Hierarchies all from the same dim. 

					2021			2022
					Jan	Feb	Mar	Jan	Feb	Mar
Top Level					10.51%	…	…	…	…	…
	Level A Item 1				0.91%	…	…	…	…	…
		Level B Item 1			0.16%	…	…	…	…	…
			Level C Item 1		0.14%	…	…	…	…	…
				Level D Item 1	0.08%	…	…	…	…	…
				Level D Item 2	0.03%	…	…	…	…	…
				Level D Item 3	0.02%	…	…	…	…	…
					…	…	…	…	…	…
					…	…	…	…	…	…
				Total	10.51%	10.68%	10.85%

 At the moment with my % DAX

% of People =

DIVIDE (

    COUNT('Fact'[personKey]),

    CALCULATE (COUNT('Fact'[personKey]),

        ALLSELECTED ()

    )

)

It seems to be creating the Percentage across the columns.

But the Totals I am getting for the whole year and Month in the column arent coming out at 100%

So I dont want to know the percentage for the Row Filter across year and Months (Columns) 

I want to know the percentage across all the row filters for the one Academic year and month

I just dont know how to go about creating a % for this? 

Anyone have any ideas on this one?

[amitchandak]

@DebbieE , You need removefilter from the date table

% of People =
DIVIDE (
COUNT('Fact'[personKey]),
CALCULATE (COUNT('Fact'[personKey]),
ALLSELECTED ('Date')
)
)

or

% of People =
DIVIDE (
COUNT('Fact'[personKey]),
CALCULATE (COUNT('Fact'[personKey]),
ALLSELECTED (Table[Year], Table[Month])
)
)

[DebbieE]

Unfortunately this isnt working for me.  And will confuse the report readers. I have changed the % Measure

I tried it with the date in in ALLSELECTED.

I tried it with the month and Year in ALLSELECTED

And I tried it with just the date table in ALLSELECTED

Now I get 9.97% as the total and the % of the top level group when it should be 100%

at the Level 2 level all he % Sum up to 119% which isnt correct either. So this isnt working for me