cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Agnethe Frequent Visitor
Frequent Visitor

Percentage of grand total

Hi

 

I hope you can help me with this problem. I  have a table with four columns:

  1. Customernumber
  2. Customername
  3. Sales
  4. Sales shown as Percentage of Grand total

My table contains 50 customers (50 rows). Now I would like to filter the Customernames by using advanced filter to only select the 10 customers with the higest sales. This is fine, but when I do this, the Sales shown as percentage of Grand Total, is based on the Grand Total of only the 10 customers. I need to show it as a percentage of the Grand Total of the 50 customers.

 

Is this possible?

 

Thanks.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: Percentage of grand total

@Agnethe

 

Hi, try with this measure:

 

% of Grand Total =
DIVIDE (
    SUM ( Table1[Sales] ),
    CALCULATE ( SUM ( 'Table1'[Sales] ), ALL ( 'Table1'[Customer Name] ) )
)

Regards

 

Victor

Lima - Peru




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
Vvelarde Super Contributor
Super Contributor

Re: Percentage of grand total

@Agnethe

 

Hi, try with this measure:

 

% of Grand Total =
DIVIDE (
    SUM ( Table1[Sales] ),
    CALCULATE ( SUM ( 'Table1'[Sales] ), ALL ( 'Table1'[Customer Name] ) )
)

Regards

 

Victor

Lima - Peru




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Microsoft v-huizhn-msft
Microsoft

Re: Percentage of grand total

Hi @Agnethe,

As I test, the solution @Vvelarde posted is right. Please try and check if it works fine. Please mark the right reply as answer if you have resolved your issue, so more people will benefit from here. Please feel free to ask if your problem still stay there.

Best Regards,
Angelia

Agnethe Frequent Visitor
Frequent Visitor

Re: Percentage of grand total

Thank you very much, exactly what I was looking for.

Regards,

Agnethe

Highlighted

Re: Percentage of grand total

Hi...I have the same problem but also last year:

 

I need the same but using previousYear function...I did this but it doesnt work: 

 

DIVIDE(SUM(Vista_TGT[Cantidad]),CALCULATE(SUM(Vista_TGT[Cantidad])),PREVIOUSYEAR(Vista_TGT[Fecha]),ALL(Vista_TGT[Expr3]))

 

Any idea how to fix it?

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)