Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
87 | |
73 | |
54 | |
43 | |
37 |
User | Count |
---|---|
98 | |
64 | |
54 | |
48 | |
45 |