March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
85 | |
69 | |
54 | |
45 |
User | Count |
---|---|
204 | |
105 | |
98 | |
65 | |
54 |