divide by grand total in powerpivot table

[jersey]

Hi Everyone,

I need some help. please. I have a powerpivot chart with 60 leads. my overall fixed cost is $5,000. how can i write a Dax formula to take the Grand Total of 60 and divide by $5,000.


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]leads
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Channel 4
[/TD]
[TD]20
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]People magazine
[/TD]
[TD]30
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NYTimes
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Grand Total
[/TD]
[TD]60
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[MD610]

If you table is called LeadTable:

=CALCULATE(SUM(LeadTable[leads]), ALL(LeadTable))/5000

 

[jersey]

If you table is called LeadTable:

=CALCULATE(SUM(LeadTable[leads]), ALL(LeadTable))/5000

thank you Mike. you are the best.