I want the option where i can customize the totals as per my requirement. The present scenario gives us the option to either display totals or not . But i think if there is a option where we can customize the totals to not just simply sum up the data, but rather applying filters on what data needs to be summed that is being displayed. There might be certain rows which we don't need in our final total.
I'd like to have better control over how the total row calculates each column in a table. For examples, sometimes I might want the value to be "Don't Summarize" for each row but I want the "Total" row to have the sum of all values. Right now, if set to "Don't Summarize", it doesn't show any total. Similarly, I'd like to be able to set how I want a measure aggregated in the "Total" column. Right now, it seems to use the same functions used in the measure for the total calculation which isn't always what I want. Here's an example use-case: https://community.powerbi.com/t5/Desktop/Change-the-way-total-of-column-is-displayed/m-p/718776 Someone gave me a complicated way to achieve what I want but it seems like it should be so much simpler than this!