Skip to main content
Microsoft Idea

Power BI

Merged

Provide options for Matrix and Table "Total"s

Vote (2) Share
Pat M's profile image

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.