Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have this table
ID TotalNumberofItems
1 5
2 2
3 4
What I need is a grand total, something like
ID TotalNumberofItems Grand Total
1 5 11
2 2 11
3 4 11
Or is there a way to have a "dummy" row at the end to total these, as such:
ID TotalNumberofItems
1 5
2 2
3 4
DummyRow 11
Solved! Go to Solution.
Duplicate your table > Highlight the column you want to get the grand total from > Transform > Statistics > Sum
Rename 'Table (2)' into something more useful like 'Grand_Total'
Go back to original table > Add Column > Custom Column > enter in whatever you just named the grand total
All done!
Duplicate your table > Highlight the column you want to get the grand total from > Transform > Statistics > Sum
Rename 'Table (2)' into something more useful like 'Grand_Total'
Go back to original table > Add Column > Custom Column > enter in whatever you just named the grand total
All done!
Now thinking is there an easier way, my thinking is if I duplicate the table and it is pulling data when refreshing then it is refreshing 2 tables with the same data instead of 1 table..
Is Dax an option here ?