Pat M on 27 Feb 2021 11:55:41
It would be great if a toggle could be added to the Table and Matrix visuals to change how subtotals are calculated. Getting subtotals correct for measures is arguably the most frequently asked question in the Power BI community. Rather than explaining how to do SUMX(VALUES( ...), [Measure]) or SUMX(SUMMARIZE(...), [Measure]) every time, it would be so much easier to say "change the toggle in the format options".
Option 1 - the way it calculates now (All Rows; no filter on the column(s) in the visual)
Option 2 - choose the desired aggregation (SUMX, AVERAGEX, MINX, MAXX) and calculate it using SUMMARIZE for the columns in the visual