The total value of table visual should be another calculation

[rschaudhr]

Hi All,

I have a request from my client who wants to see a new calcuation instead of the total in the table visual. Here is the image of the report.  

So the bottom calcuation is taking the top value of 16M dividing by summing of the total (excluding 16M from the top).

Is there way to display this in a dynamic fashion? Right now in table visual you can only display the total. 

Thank you 

[kpost]

Add a measure like this and use it as a column in your chart.

Base Salary Custom Total =

IF(ISINSCOPE('Table'[Named Executive Officers]), SUM('[Total Comp]),

"CUSTOM TOTAL"
)

Insert whatever calculation you want where it says "CUSTOM TOTAL".

This is what it would look like.  Note that you can have whatever you want display on the "Total" line using this method.