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
makromer
on:
Fabric Data Pipeline should be able to execute dbt...
on:
Customers should ereceive notifications for all th...
miguel
on:
Recent Data and Recent Connections