Forum Discussion
Grand total
Hi all, I have a “problem”, I want show in the pivot the Total average for the sellout, is possibile create a formula with dax? I just want the results that I have if I have the grand total for row...
I'm not sure where else to go from here but I have attached the PBIX file. Seems to work for me with the parameters you have given. Hopefully you can figure it out from there.
it seems works on Power BI, maybe the problem is that i use power pivot on excel and than i create a pivto table?
Perhaps although I would expect that if your pivot table was configured like the matrix visualization in Power BI then it should work the same. I don't do Excel though.