Window_avg and total in power BI

[asdf1608]

I am trying to convert the tableau calculations to Power BI.

There are few issues I faced while converting the dashboard.

1. Window_avg in power BI - calculating the windows_standard Deviation in poewr BI

WINDOW_STDEV(SUM([Sales]))

2. TOTAL(SUM([Qty LB]) - I am not able to understand difference between Total and sum, but the Calculation dax is

sum([Sales1])/total(sum([Sales1))

I am not getting the result I need in power BI.

Power BI file : Sample File.pbix

I am not exactly sure of how to create the above two calculated field in power BI.

Help in this is needed.

Thanks in advance

[Greg_Deckler]

@asdf1608 There is no TOTAL function in DAX that I am aware of or WINDOW_STDEV. Is that Tableau code? 

[asdf1608]

@Greg_Deckler Yes it is available in tableau and the result of that, I have attached it as screenshot.

I am not sure of how to convert that to Power BI DAX.

Please help me in this

[Greg_Deckler]

@asdf1608 The Sales measure is just SUM('Sheet1'[Sales]). What does the other measure represent? It seems like a percent of grand total but I don't think that is quite right. See attached PBIX below signature.