Why the total is not 100%?

[Andrew_na_lang]

Hi Fam,

I need help! 

I tried to calculate the perc of all subcategories to the total category, however, the total percentage is not equal to 100%. 
The PercSubCatOverCatTotal should equal to 100 %, right even if I change the date? 

 
The measure I use:

 

[Andrew_na_lang]

@amitchandak  I now know why it is not 100%. If I update the date slicer, the total percentage decreases. 
My dataset is from Jan 1, 2021, to November 17, 2021. The measure I created is working fine and showing 100% as total but when I change the date, it decreases. Do you know the solution to that?

[amitchandak]

@Andrew_na_lang , use removefilters on the second column in the matrix row and check