cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
leudyston Regular Visitor
Regular Visitor

Calculating Current Stock with Filters

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

 

 

image.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
leudyston Regular Visitor
Regular Visitor

Re: Calculating Current Stock with Filters

Okay I solved !!

 

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

 

1 REPLY 1
leudyston Regular Visitor
Regular Visitor

Re: Calculating Current Stock with Filters

Okay I solved !!

 

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