cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Percentage of total row

Capture.PNG

above shown column is determine by the two other columns in same table. when comes to total of the column, all the precentages were aggregating. how do i show the precentage of the total column?

1 ACCEPTED SOLUTION

Accepted Solutions
edhans Super Contributor
Super Contributor

Re: Percentage of total row

If your data is in a table called TestData, first column is called FIRST, and second called SECOND, you need three measures:

Total First = SUM(TestData[First])

Total Second = SUM(TestData[Second])

Percentage = DIVIDE([Total First],[Total Second],0)

Drop those three measures into a table or matrix.

 

You could probably do this in one measure, but the above makes it clear what is going on, and it means you have 100% explicit measures in your table, which you should.

View solution in original post

5 REPLIES 5
edhans Super Contributor
Super Contributor

Re: Percentage of total row

Your ROI measure should be something like = DIVIDE (numerater, denominator, alternate result if denominator is zero)

 

then put that in your table. In the total row, it won't add the percentages, but divide the total numerator by the total of the denominator.

If you need more specific help, post a sample of the data and a more complete picture of the visual.

Anonymous
Not applicable

Re: Percentage of total row

Capture2.PNG

 

i need to get this highlighted one

edhans Super Contributor
Super Contributor

Re: Percentage of total row

If your data is in a table called TestData, first column is called FIRST, and second called SECOND, you need three measures:

Total First = SUM(TestData[First])

Total Second = SUM(TestData[Second])

Percentage = DIVIDE([Total First],[Total Second],0)

Drop those three measures into a table or matrix.

 

You could probably do this in one measure, but the above makes it clear what is going on, and it means you have 100% explicit measures in your table, which you should.

View solution in original post

Anonymous
Not applicable

Re: Percentage of total row

i have try this and for some its working but for some its not. 

edhans Super Contributor
Super Contributor

Re: Percentage of total row

You are going to need to provide your full data. What I provided works for the snippits, but you have something else going on in your model that I am not accounting for, and I cannot guess based on a few screen caps pasted in the post.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 272 members 2,903 guests
Please welcome our newest community members: