Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
As per below the 2nd last column has blank on totals row of the table.
The first column also has blank in some detail rows but as can see it shows a total on table footer (this column direct from fact table) without any fancy formulas.
sum(sales),
2nd last column = sum (sales) * price from dimension table.
How can we best ensure totals always show on matrix/table footer?
Thanks
@po , You need to share more details
Refer why my grand total is wrong
https://www.youtube.com/watch?v=ufHOOLdi_jk
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.