I have a number column in Table report.
I don't need to Sum() this column (marked as "Don't summarize"), but I still want to see Total sum for this column.
I have several lines for each date with different figures and I need to see them all.
For example I have lines with 3, 5 & -7fro today. If I mark the column as "Sum" - I'll have just one line with 0.
But I need to see all the lines and have Report Total at the same time.
I mentioned in the question that I can't mark "Sum" - it must be marker as "Don't summarize".
In this case Grans Totals do not appear regardless of "Totals" setting.
If that is the case, I am afraid there is no such a option to show total row in your table visual. Thank you for your understanding.
By the way, why cannot mark it as "SUM"?
Regarding "why" - again, I mentioned it in my question (with some figure corrections):
>> For example I have lines with 3, 5 & -8 for today. If I mark the column as "Sum" - I'll have just one line with 0.
>> But I need to see all three lines and have Report Total at the same time.
Currently as a workaround I've added a line ID field to report and made the column as narrow as possible (so it's almost invisible) but I don't like this solution.
For the ID field, you can right click on the ID column in the table view and mark "Hide in report view" --> This will not show in the report view.
I also faced the same issue today, I added a card visual at the end to show totals and in tables I made as don't summarize. This overcame my problem.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.