Forum Discussion
Remove Negative Values with Calculate
Hi,
Try this revised measure
=if(HASONEVALUE(ditens[Tamanho]),IF([Calc Sugestão de Compras]>=0,[Calc Sugestão de Compras],0),SUMX(SUMMARIZE(VALUES(ditens[Tamanho]),[Tamanho],"ABCD",IF([Calc Sugestão de Compras]>=0,[Calc Sugestão de Compras],0)),[ABCD]))
Hope this helps.
Hi,
I'd like to help but the file size is very large. Trim the file to a couple of MB's and then share the download link.
Hello Ashish_Mathur, thank you for helping me with this question.
I decrease the file size to 5Mb, the Stock Balance values will not be the actual values, but what matters is how much I need to calculate correctly.
Hi,
Try this revised measure
=if(HASONEVALUE(ditens[Tamanho]),IF([Calc Sugestão de Compras]>=0,[Calc Sugestão de Compras],0),SUMX(SUMMARIZE(VALUES(ditens[Tamanho]),[Tamanho],"ABCD",IF([Calc Sugestão de Compras]>=0,[Calc Sugestão de Compras],0)),[ABCD]))
Hope this helps.
Hi Ashish_Mathur,
In the context of the First Table is correct, but when I filter more than one store, the second table that shows the values per store are not correct, I tried to change the measure but it is well advanced and unfortunately I could not.
Note: In the pbix file I had to move almost all the stores, I left only the movement of the Manhattan and Aldeota stores, I think it is important to inform this so that you can understand, since when filtering any other stores, the values will be zeroed.Thank you so much for helping me.
Merry Christmas
