How to add rows at the bottom of table?

[aulona12]

Hello all, 

I am hoping you can help. I want to add the three rows at the bottom of the table but having a hard time doing that in powerbi. Any suggestions? 

Grand total = just the total of the columns that are presented as numbers ( i want to leave the total for percentage columns blank)

Benchmark as % = grand total for each column that is presented as number  /  grand total of Total New column  (this nees to be present only in the columns that are formatted as percentage, just as displayed in the screenshot) 

Medicare Benchmark for Family Pratice = This is manually entered number. It will continue to stay this way and updated by user every month. 

Is there any way to do all this and achieve the same result as in the screenshot displayed above? 

[PaulDBrown · Accepted solution]

See if this works for you. Beware that since the matrix is built using custom rows, the totals scroll, so are only visible at the bottom of the rows. As an alternative, you can create a summary table (depicted) to keep the totals visiable at all times. If you actually prefer this route, you can simplify the model to an extent.

I've attached the sample PBIX file

[aulona12]

thank you. this is exactly what i was looking for 

[aulona12]

anyone? any suggestions?

[PaulDBrown]

Are you going to filter the rows via a slicer?

[aulona12]

no

[PaulDBrown]

A couple more question. What is the actual structure of your data? Is the number of columns static or do they grow over time? Are they different metrics or the same metric with different segmentation (99202, 99203...)?

[aulona12]

The structure of this particular data will remain the same. The number of columns will remain the same, just the amount of rows will prob grow over time. The metrics are what was displayed in the sample file. all the other numbers except the values that are in the last three rows are imported on powerbi using an excel file which is created with python. I need to add the last three rows using powerbi 

[PaulDBrown]

Can you please provide sample data or mockup PBIX file (via a cloud service)?

[aulona12]

It is not letting me attach excel file here. 

I had to upload it here. Here is the sample file. https://easyupload.io/k7rr5j