Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help Creating Gross Profit Measure

I am in a bit of a situation where I am stuck trying to calculate Gross Profit. My Table isn't broken out to an ideal scenario, thus I am relying on some DAX to get this solved.   CATEGORY is the D...
Need Help
  • charancvg's avatar
    charancvg
    7 years ago

    Use the calculate function to create a measure like

     

    Calculate(Sales - Cost of sales, Category = Sales)

     

    Or you can breakout the column into 3 new columns and then build a measure to calculate the values.

     

     

charancvg's avatar
charancvg
Frequent Visitor
7 years ago

Use the calculate function to create a measure like

 

Calculate(Sales - Cost of sales, Category = Sales)

 

Or you can breakout the column into 3 new columns and then build a measure to calculate the values.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unfortunately, it's not that easy for this case. I am provided with the all the category is one column and need to imbed some kind of conditional logic to look for when the categories are met. 

 

 

  • charancvg's avatar
    charancvg
    Frequent Visitor
    7 years ago

    Can you email a sample of your data? 

    I can work on it later in the day.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello,

       

      This message went to spam so I am just seeing it. However I got it to work!