DAX Measure to get %

[Anonymous]

Hi, 

I am trying to create a matrix table for the total stock quantity and value for 2 different months. I want to get the % of stock value (versus the total stock values in that particular month) but seems like the formula that I used below is comparing against the total stock values across 2 months. 

% Total Value = [Total Value($)]/CALCULATE([Total Value($)],ALLEXCEPT('Age Inventory 0262','Age Inventory 0262'[Closing Date]))

As I am very new to DAX, appreciate if anyone could help me with the formula. Thanks !

[Anonymous]

@Anonymous 

I can't tell you 100% what's wrong because one has to see the model to be able to. But you should definitely take a good look at this: Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

because I sense you might be using ALLEXCEPT without a full understanding of how this calculate modifier behaves.