Calculate numbers from the same column

[iluvfnky]

Hey,

Is it possible to divide data from the same column. I have categories of which I want to get a ratio of sales. All the sales data sits in one column. Is it possible to write a dax formula that divides that data as required?

Thanks,

 

[ImkeF]

Try this:=SUM(Table[Value]) / CALCULATE(SUM(Table[Value]), ALL(Table[GroupingAttribute]))

as seen in: PowerPivot DAX: CALCULATE is a supercharged SUMIF « PowerPivotPro