Market Share Percent In Ribbon Chart - % Of Column Total
We are trying to mimic The 100% stacked bar chart's % of column total calculation on a ribbon chart. So essentially a market share % of total calculation for each date we have. We've tried creating a measure that we thought would work but it has not: AllDivisionTracking := CALCULATE ( [TrackingNumbers], ALL ( Divisions ) ) PercentOfTotal := DIVIDE ( [TrackingNumbers], [AllDivisionTracking] ) This measure does not seem to work when inserted as the measure on a ribbon chart. The ribbon chart seems to make this calculation over the entire date range instead of limiting it to each day as we would have expected.
Measure to Sum specific rows and the subtotal/grand total to still display the Actual Total Sales
Hi Power BI Community, I have a table displayed like below, with column definitions as follows. Tot Sales = Sum(Sales) My Formula = Is my attempt to get the expected result. Expected Result = How I want the calculation to work. Here is the DAX I wrote SUMX(SUMMARIZE(SalesFact,'Territory'[Territory ID],'Product'[Sales Role]),IF('Product'[Sales Role]="Cat 1 Rep",CALCULATE([Total Sales],'Product'[Cat 1 Product]="YES",ALL('Product')),IF('Product'[Sales Role]="Cat 2 Rep",CALCULATE([Total Sales],'Product'[Cat 2 Rep Product]="YES"),CALCULATE([Total Sales],'Product'[Cat 3 Rep Product]="YES")))) The above formula gives me the expected result against the Cat 1 Rep row, but fails to get the expected sub total and grand total. The field "Cat 1 Rep Product" in above formula is a flag which identifies products from product table that fall into Cat 1. "Cat 2 Rep Product" and "Cat 3 Rep Product" are similar columns. What I want is - Sum the results for Cat 1 Rep row and Cat 2 Rep row and display it against the Cat 1 rep, other rows shouldn't be impacted. Also, I do not want this manipulation to impact the Column subtotal or grand total and should display the actual total that is (Cat 1 Rep Product + Cat 2 Rep Product + Cat 3 Rep Product) and NOT ( (Cat 1 Rep Product + Cat 2 Rep Product) + Cat 2 Rep Product + Cat 3 Rep Product). Is this possible? Thank you all!
