Time Measure Issue (Chart x Table)

Hi v-deddai1-msft, Thanks for giving your time to help me.

The code that you shared worked flawless on the "test.pbix" but i couldnt make it work out on "Real_Report", can u help me figure out what iam doing wrong, please?

I have 2 type's of errors:

1 - Wrong Calculation when December is selected with other's month's, ex:

Correct Period_December/2019_Value = -25.013,80
Correct Period_January/2020_Value = 4.105,60
Correct Total sum should be = -20.908,20




2 - Some month Value's are wrong even if i select only them, ex:

Correct Period_May/2020_Value = 2.638,0




OBS: Like i said on my past post's, my old measure "Old_Period_Value" do work if i select just 1 month, you can use it as a reference to identify if the values are correct or not, or calculate on the table too.

Real_DB.pbix