I’m trying in vain to formulate a DAX formula that will show me Category shares and within that Brand shares. I have a matrix, and in the rows I have category (Sub family name in the file) and in the columns I have Brand, so I need to show by rows the Brand share within that category and at the end it should show the Category weight. Also, at the end of the column it should show the Brand weight of business among all Brands. Is this possible to show in a matrix.
Appreciate if someone can show me a workaround. Below is the file.
EPOS.pbix (766.8 KB)