Skip to main content
Microsoft Idea

Power BI

Needs Votes

Fact column subtotals in data view

Vote (1) Share
UKanExcel (Mark Robinson @ Cloud2 Ltd)'s profile image

UKanExcel (Mark Robinson @ Cloud2 Ltd) on 01 Aug 2018 17:27:08

The recent addition of filtering and sorting in data view is fantastic. This feature will be very useful to those developing data sets. What would help developers even more, particularly those adding calculations to their data sets, would be seeing a subtotal for each fact column in the data set - that changes in line with any filters applied. This would hep developers to check their calculations are returning accurate results - particularly where filters have been applied to the calculation itself using the CALCULATE () and FILTER () functions.