cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Super User II
Super User II

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.


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

Proud to be a Super User!


MCSA: BI Reporting

View solution in original post

5 REPLIES 5
Super User II
Super User II

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.


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

Proud to be a Super User!


MCSA: BI Reporting
Anonymous
Not applicable

Re: Percentage of total row

Capture2.PNG

 

i need to get this highlighted one

Super User II
Super User II

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.


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

Proud to be a Super User!


MCSA: BI Reporting

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. 

Super User II
Super User II

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.


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

Proud to be a Super User!


MCSA: BI Reporting

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors