Once "total column" in "Format"/"Subtotals" is on, I get two totals at the right end. Do you know how I can fix this?
It seems that I can only get one total on my side. How about the result if you turn off subtotals for the Matrix Preview visual? Are you using the latest version 2.47.4766.801 (June 2017) of Power BI Desktop?
Hi Herbert, I confirm I have the latest (June) version of the Desktop Client. Also, if I turn off the "Total column" in subtotals" then both columns with totals disappear. Any other ideas?
Is it possible to share your PBIX file which can be used to repro to me? You can upload it to online file service like OneDrive and then send the sharing link to me.
Dear Herbert. I think I understand the rationale behind the Double totals. It seems that as I drill down to monthly data from yearly, the first sums is supossed to add the monthly data and the second sum is supossed to add data for 2 or more years. If I have monthly data for only one year then Double totals are presented.
I see that the "Grand Total" is available only for columns. Is there a way to insert "Grand Total" on rows?
No, we cannot only insert "Grand Total" withour subtotal on rows. Please vote on related ideas like below ones.