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.
