Forum Discussion

leudyston's avatar
leudyston
Helper I
8 years ago
Solved

Remove Negative Values ​​with Calculate

Hello friends, I need to create a measure that can only bring the positive values ​​of an expression and that the total of this measure is also calculated only by adding the positive values, I have t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

     

leudyston's avatar
leudyston
Helper I
8 years ago

Hello Ashish_Mathur

 

After fixing the error in the ESTOQUE ATUAL, continue with other validations and encountered this problem. When the context brings the result by Store, it is adding the negative value with the positive, giving divergence in the final value of the measure. Affecting the value per line of the measure SUGESTÃO DE COMPRAS.

 

Can you help me find this problem as you created it?

 

As this error only appeared when I was validating another store, I had to add its moves in the .pbix file, then follow the updated file link with store 33 MESSEJANA.

FILE .PBIX

 

 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

I cannot appreciate the problem - it is simply because of the language.  I may not be able to help.