Power BI forces us to use complex workarounds just to fix total calculations in running totals and similar scenarios. Instead of making users struggle with DAX tricks, why not add a simple, intuitive solution? Proposed Solution: Introduce a new field or checkbox that allows users to define the type of summarization for each column in a visual (e.g., None, Sum, Avg, Count, Min, Max, Mode, StdDev, etc.) Make it a Visual Calculation, just like the existing ones (Running Sum, Moving Average, etc.) Why This Matters: This would eliminate the need for hacks to control total calculations, specially in Tables and Matrixes affected by slicers and complex measures It follows the same logic as existing Visual Calculations, making it easy to implement It would be a huge improvement for anyone working with cumulative calculations in Power BI
... View more