cancel
Showing results for
Did you mean:
Highlighted
Anonymous
Not applicable

## Percentage of total row

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

## 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.

Proud to be a Super User!

MCSA: BI Reporting
5 REPLIES 5
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.

Proud to be a Super User!

MCSA: BI Reporting
Anonymous
Not applicable

## Re: Percentage of total row

i need to get this highlighted one

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.

Proud to be a Super User!

MCSA: BI Reporting
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

## 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.

Proud to be a Super User!

MCSA: BI Reporting

Announcements

#### 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?

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

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

Top Solution Authors
Top Kudoed Authors