Calculating Profit Margin Year Wise

[Hemanth_PBI]

Hi,

I'm trying to calculate profit margin % for each year. Instead of showing profit % for each year i'm only getting static percentage. Can anyone point what i'm missing here.

GP_Margin = DIVIDE([GROSS PROFIT],[Total sales],0)

GROSS PROFIT = [Total sales]-[total cost]

total cost = SUMX('Sales GP Report','Sales GP Report'[Standard Inv Cost Amount])

 

[amitchandak]

@Hemanth_PBI , hope all of these are measures [Total sales],[total cost], and GROSS PROFIT 

GP_Margin = DIVIDE([GROSS PROFIT],[Total sales],0)
GROSS PROFIT = [Total sales]-[total cost]

if the cost is coming from a different table, make sure you are using a common date table in visual and formula

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...