topic Profit Margin calc in DAX Commands and Tips

Profit Margin calc

CMajka8 — Thu, 23 Sep 2021 16:51:06 GMT

Hello -

I am having trouble with the profit margin calculation. Here are my measures:

1. Total Revenue = SUMX( Sales, Sales[Order qty] * Sales[unit price] )

2. Total Cost = SUMX( Sales, Sales[Order qty] * Sales[unit cost] )

3. Total Profit = [Total Revenue]-[Total Cost]

4. Profit Margin = DIVIDE( [Total Profit], [Total Revenue], 0 )

However, when I show profit margin in a visual, all of the items in the category have the same profit margin. Any suggestions?

Thanks

Re: Profit Margin calc

Greg_Deckler — Thu, 23 Sep 2021 17:06:47 GMT

CMajka8 This generally indicates a missing relationship somewhere but if the Total Revenue and Total Cost columns in your visual are the measures you indicate that's rather strange.

Re: Profit Margin calc

CMajka8 — Wed, 29 Sep 2021 11:47:38 GMT

It turns out the dataset was manually generated and the profit margin calc was indeed accurate. Sorry for the confusion.