Calculating Current Stock with Filters

[leudyston]

Hello friends, this is the measure I am using to calculate the CURRENT STOCK OF STORES, being that I need to filter only the stock of the stores that have moved in the stock at least until ten days ago or stock of Stores with active register. My measurement is working correctly in the First table, but in the second table when filtering more than one store it is repeating the ESTOQUE ATUAL for all stores. The correct thing is that each store has its ESTOQUE ATUAL and the sum of these stocks is the TOTAL that is in the First Table.

Estoque Atual = CALCULATE([Estoque];FILTER(ALLSELECTED(dlojas);[Data Estoque]>=TODAY()-10||dlojas[status]="INATIVO"))

I need your help to identify where the error is in my measure ESTOQUE ATUAL.

I am making the .pbix file available

File .pbix

Thanks and Merry Christmas

[RooseveltDorea]

Olá boa noite, estou quebrando a cabeça para criar uma fórmula para calcular a cobertura de estoque e giro. Pode ajudar?

Abraços

[leudyston · Accepted solution]

Okay I solved !!

Estoque Atual = CALCULATE([Estoque];FILTER(dlojas;[Data Estoque]>=TODAY()-10||dlojas[status]="INATIVO"))