Forum Discussion

MattSwan's avatar
MattSwan
Frequent Visitor
5 years ago

Missing Totals from Table Visual

Hi there,   My first post! Fairly new to Power BI. I think this is an issue with how I've setup my query, but here goes.   I have two tables linked via an ID. One containing Student details and o...
moizsherwani's avatar
moizsherwani
Icon for Continued Contributor rankContinued Contributor
5 years ago

Welcome to the world of PowerBI 😀. One of the first problem Excel migrants face is the same one you are facing (the totals don't add up or aren't correct). The totals in PowerBI don't work as you might think. In your case, when the formula comes to the total part of the table it considers the 9 and the 6 (the totals of the first two columns as per your snippet) and evaulates the formula based on these two values which is why you are probably always getting "0". There is a number of way to add these numbers and without knowing your exact data model / end goals I cannot suggest the best one but one method would be to use an aggregator function such as SUMX (see below) and drag it into the table and see if the correct result shows up in the total (again this may not be correct becase I do not know the table structure for the attendance table)

 

 

 

 

PA Puplis Total = SUMX (attendance, [PU Pupils])