Forum Discussion

tlenzmeier's avatar
tlenzmeier
Icon for Helper II rankHelper II
8 years ago
Solved

Percent of Column Total

Hello,   In what would apparently seem like a staightforward thing to do, I am trying to capture the percent of each contract with a customer to the total contract amount with said customer. For ex...
Need Help
  • dramus's avatar
    dramus
    8 years ago
    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)
dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
8 years ago

I created a table with just the companies and then added column based on this:

 

 

Total Contract value = sumx(Calculatetable('Contracts',filter('Contracts',[Company]='Companies'[Company])),[Contract Amount])

 

Then on the Contracts table I created another column based on this:

 

 

Percentage of Total Contracts = [Contract Amount]/related('Companies'[Total Contract Value])

 

 

 

Which gave the following results:

 

 

I can let you have the PBIX file if you would like.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greetings 

Can you kindly share the file please