Forum Discussion
Helper IIPercent of Column Total
Percent of Total = DIVIDE(sum('Contract'[ContractAmount], RELATED('Vendor'[Vendor Total]), 0)Take out that sum. You don't need it.
Percentage of Total Contracts = divide([Contract Amount],related('Companies'[Total Contract Value]),0)
Community ChampionJust use the "Show value as" | "Percent of grand total"?
Click the little arrow drop down on your value column in the Visualizations area and choose those menu options.
- tlenzmeier
I need to store a value since I have to then multiply that percentage against another value. In this example, the customer has a credit limit of $750,000, so each row in the table needs to have the percentage multiplied by the credit limit.
- Greg_Deckler
OK, what you probably want is an ALLEXCEPT clause instead of ALLSELECTED. Sample data please.
- tlenzmeier
Contract Number VendorID Contract Amount Pct of Total 7223DIAM 49113 $959,574 41.99% 7239DIAM 49113 $805,790 35.26% 7351DIAM 49113 $519,670 22.74% $2,285,034 100.00% The percent of total is a simple formula in Excel. The percentages will subsequently be used in another measure/calculation. If I use ALLEXCEPT, all except what? The VendorID is the primary key in the vendor table and subcontract number is a dependency.
