Percent usage in matrix type table in Power BI.
I am in doubt as to how to perform percentages when I go to the next level of drill down in my matrix, the first line was ok, but when I go down the level, 100% is displayed in all data. My base formula is: Total Sales Underline = CALCULATE([Sale Qty Weight KG], ALLSELECTED('Item'[Underline - Name])) % Share Underlines = DIVIDE([Sales Qty Weight KG], [Total Sales Underlines]) but there are other levels that need the percentage. Can someone help me? how I use the other lines, like: Item [Group - Name] Item - Description [Description]
