Forum Discussion
Calculate and Plot Percent Mix
Thanks Sean. I already have several other charts on my report, so it is already sliced to Category.
Actually, I am managing the report for the entire org, and different teams own different Product Categories, so I have an ALL tab for the entire org sales, and then multiple tabs each sliced to a specific Product Category. So, doing away with the slicer is not an option...
The % Mix was a new request that came in after the report was already built and in use. So, now trying to add % Mix to my "Sales by Product" chart. And hence the difficulty of calculating % Mix against Total Sales.
In your solution, how is Overall Sales different from Total Sales? I am wondering why my ALL function didn't work.. I have ALL(Sales[Category]) - should I not have the column specified in the ALL function?
mur2za Yes to get the overall total at ALL levels - don't specify a column!
Look at the picture and you'll see what I mean.
Your function did exactly what you asked it to do => gave you the overall total but only at the Catgeory Level.
Yup, that worked! I removed the "Category" column from my ALL function and it gave me the correct results!
Thanks for your help Sean!
Mur2za.