Pat M on 12 Oct 2021 02:01:18
Getting the right "total" on a matrix/table visual remains something that confuses many (e.g., many questions in the community). It would be great to have the option to choose how the "total" is calculated. The user should be able to choose the current behavior (i.e., no row filters) but also one of several aggregation options (sum, average, min, max). This would make it so new users wouldn't have to build and/or understand measure like - SUMX(VALUES(Table[Column]), [Measure]) for example.
Merged with
Matrix/Table grand totals with Measures