Forum Discussion
ADSL
Post Prodigy
Post ProdigyCalculate the Contribution % by Province
Hi BI Community Team, I want to calculate the contribution % by province of total sales as the table below. ==> Formula = Grand Total Sales / Total Sales by Province Any suggestion of...
jgeddes
Super User
Super UserAre you looking for this
Contribution3 % =
Var _Total_By_Client =
CALCULATE(
SUM('Order'[Amt No VAT]),
ALL('Order'[Province])
)
Var _clientTotal =
SUM('Order'[Amt No VAT])
Return
DIVIDE(
_clientTotal,
_Total_By_Client,
0
)
