Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Fix Running Totals Without Hacking!

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:

  1. 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.)
  2. 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
Status: New