Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Implement SUM measure totals in Power BI (without using DAX)

by Chandra Vadana Rajamohan | Nov 02, 2022 |

In Microsoft Power BI, quite often, the results in total rows do not correspond to the sum of the individual rows when DAX measures are used. This is because the total is computed based on the DAX formula. To obtain the correct total, one may have to write complicated DAX queries which is quite a struggle for less-experienced Power BI users.   

Inforiver provides you options to configure totals the way you want, out of the box. Totals can be aggregated easily using the option - Row Aggregation Type. By default, it is set to Formula – i.e., it calculates totals & subtotals based on the formula. Changing the Row Aggregation Type to type Sum ensures that the individual rows are added to calculate totals. 

(Note: Inforiver also offers other aggregation types such as minimum, maximum, average, visible rounding etc.) 

Row Aggregation Type

In the example below, we need to calculate the number of categories with revenue > 200m. We see that there are 3 such categories. However, the formula for Score 1 uses Formula aggregation, which applies the formula to the total row as well, returning 1. Meanwhile Score 2 uses Sum aggregation, and therefore returns the sum of the individual rows which is 3. 

Measure totals

Read these blog to learn more about managing aggregation and calculating remaining budget.  

Try Inforiver today by installing the free trial version of Inforiver Matrix from Appsource.  

Learn more about visual calculations in Inforiver here.

Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
5920 Windhaven Pkwy, #130
Plano TX 75093
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram