cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How to calculate % of total for a column over time series?

I need help in calculating % of the total for a column over time. I have used this dax to calculate it for "Country" 

DIVIDE(SUM(Sheet1[Value]),CALCULATE(SUM(Sheet1[Value]),Sheet1[Country] in {"USA","Canada"}),0) since I had only 2 countries I was able to plug in those values into my "in" condition but I don't want to plug in all my states into my  "in" condition. 
 
Please see the below picture
 

Capture1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
ahmedoye Resolver I
Resolver I

Re: How to calculate % of total for a column over time series?

Hi @mohammedfareed2 , to make your DAX easier to read and write, break it down this way:

  1. Amount = SUM(Sheet1[Value])
  2. State Grand Total =  CALCULATE([Amount], ALL(Sheet1[States]))
  3. % of Grand Total = DIVIDE([Amount], [State Grand Total], 0)

Remember to format your measure as a percentage afterwards.

 

If this solves your question, kindly mark it as a solution.

View solution in original post

2 REPLIES 2
ahmedoye Resolver I
Resolver I

Re: How to calculate % of total for a column over time series?

Hi @mohammedfareed2 , to make your DAX easier to read and write, break it down this way:

  1. Amount = SUM(Sheet1[Value])
  2. State Grand Total =  CALCULATE([Amount], ALL(Sheet1[States]))
  3. % of Grand Total = DIVIDE([Amount], [State Grand Total], 0)

Remember to format your measure as a percentage afterwards.

 

If this solves your question, kindly mark it as a solution.

View solution in original post

Re: How to calculate % of total for a column over time series?

Thanks. This worked.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.