Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Thanks and Merry Christmas
Solved! Go to Solution.
Okay I solved !!
Estoque Atual = CALCULATE([Estoque];FILTER(dlojas;[Data Estoque]>=TODAY()-10||dlojas[status]="INATIVO"))
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
Okay I solved !!
Estoque Atual = CALCULATE([Estoque];FILTER(dlojas;[Data Estoque]>=TODAY()-10||dlojas[status]="INATIVO"))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |