Totals on Percentages in Tables

[Anonymous]

I have a column that compares Net to Gross Sales using the formula (Gross Revenue $ - Net Sales $)/Gross Revenue $ and in Power BI it is displaying the total of that column incorrectly.

As shown below, Power BI is displaying the totals at the bottom of each row.  In the Gross Reveue $ and Net Sales $, the totals correctly display the total of that column.  In the calculated column, the totals diplayed reflects the addition of all the rows percentages (45.9%) versus what it should display (32.5%) which is (116,087.7 - 78390.6)/116,087.7 - matching the formula of the calculated column.  It there a way to get the totals in calculated columns to match the formula in that column versus just adding up the results?

[Greg_Deckler · Accepted solution]

Is your "Gross To Net Sales%" a calculated column or a measure? If it is a calculated column, change it to a measure and it should correct this problem.

[Greg_Deckler · Accepted solution]

Is your "Gross To Net Sales%" a calculated column or a measure? If it is a calculated column, change it to a measure and it should correct this problem.

[Anonymous]

It worked...I should have remembered that one...thanks for your help!

[Anonymous · Accepted solution]

It is a calculated column.  I will create a measure and see what happens.  Thx!