Weighted Average Margin for a Each Date

[MAlimalik]

Hi guys, need urgent help.

I am a new user of Power BI and I am facing a problem.

I am working on a report, where I want to show weighted avgerage margin of a PRODUCT agaisnt each DATE. I tried so much but could not get a best soloution.

Please Note: My SKU are are more than 1000 and every day invoicing volume is more than 1000. 

Thanks 

 M.Alee

[MAlimalik]

@Deku @danextian @Ritaf1983 @bhanu_gautam @BIBen 

[Deku]

Weighted Avg Margin= (

Var dailySP =

Calculate(

Sum(table[SP]),

Allselected(),

Values( table[date])

)

Var dailyCOS =

Calculate(

Sum(table[COS]),

Allselected(),

Values( table[date])

)

RETURN

Divide(

(DailySP - dailyCOS),

DailySP

)

[MAlimalik]

Hi Daku Thanks for you input.

But I am getting overall Weignted Average Margin. What I need to see is Weighted Average Margin of a product on a Specific Date. 

If you please help, that would be great for me.

[Deku · Accepted solution]

Weighted Avg Margin= 
var dailySP =
   CALCULATE(
      SUM(table[SP]),
      ALLSELECTED(),
      VALUES( table[date] ),
      VALUES( table[product] )
   )
Var dailyCOS =
   CALCULATE(
      SUM(table[COS]),
      ALLSELECTED(),
      VALUES( table[date] ),
      VALUES( table[product] )
   )
RETURN
DIVIDE( ( dailySP - dailyCOS ), dailySP )

[MAlimalik]

Thanks for your assistance. 

[sanalytics]

@MAlimalik 

Please specify how this weighted average is getting calculated.

Regards

sanalytics

[MAlimalik]

Weighted Avg Margin= (Total SP of a date - Total CoS of a date)/Total SP of a date