Forum Discussion

Jameswh91's avatar
Jameswh91
Icon for Helper III rankHelper III
4 years ago
Solved

Gross Margin

Hi I'm looking to create a measure to calculate the gross margin of our sales however on the sales table I have minus figures for returns. How do i create a measure that will ignore the minus figures, giving me a true margin?

Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Jameswh91 ,

     

    Sumx(filter(Sales, Sales[Amount]>0), Sales[Amount])

     

     

    or

     

    calculate(Sum(Sales[Amount]), filter(Sales, Sales[Amount]>0) )

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Jameswh91 ,

     

    Sumx(filter(Sales, Sales[Amount]>0), Sales[Amount])

     

     

    or

     

    calculate(Sum(Sales[Amount]), filter(Sales, Sales[Amount]>0) )