Forum Discussion
problem with share calculating
Hi! I'm building a report on a PBI desktop sheet, 3 charts are needed: 1 for segment, 1 for manufacturer & 1 for brand share - at first all calculated from total sales, and then we can select jus...
TomMartens
Super User
Super UserHey,
without some sample data and your measures it's difficult to provide some proper guidance.
But maybe you might consider separate Dimension/Lookup tables for Manufacturer and Brand (Product)
then using ALLSELECTED('ProductTable') might be of some help.
Regard,
Tom