Profit Margin calc

[CMajka8]

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

[CMajka8]

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

[Greg_Deckler]

@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.