Aging bucket based on dynamic measure

[Among_Us]

Dear All,
I m new on Power BI and stuck for the last two days but couldn't find the correct answer. I have checked almost all the previous blogs for reference but failed. Now please help me
I have a fundamental table (inventory data).
1) I created a dynamic measure named max_purchase date which is based on the user filter date and after that, I created another measure named (in-month) (in which I calculate the months between max selected date and max purchase date and also try to connect it to another table name (Aging table) but it failed to get the correct data.
Example The inventory value of Item No.AD0005 is 533 and the max purchase date is 28th May 2022 and user-selected May 2022 in the filter column so the excepted result should be 533 instead of 260 (total of current month transactions) and the aging bucket(column not measure) should be below 3 months

[v-easonf-msft]

Hi, @Among_Us 

Not fully sure what you want. Can you share relevant formula you are current using?

Please provide more details for further investigation.

Best Regards,
Community Support Team _ Eason

[Among_Us]

some one please help

[Among_Us]

Please help