Forum Discussion
Sum totals from multiple columns based on filter selection
Hi, Hope you're all doing well. Is it possible to achieve something like this: I'd like to be able to display a total value based on multiple columns where the total will vary depending on th...
Greg_Deckler
Community Champion
Community Championaridavid - Maybe, it's not very clear though. You would probably have more luck if you unpivoted those columns in your dataset. If you do need multi-column aggregation, there is a way to do it. https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-p/391698#M129
And the solution comes with a nice poem...
Hey, thanks for checking, I'll try to edit and clarify.
