Hi all,
I am writing DAX code to determine the percent of total business a given data intersection represents, and showing it in a stacked bar chart.
Specifically, in debugging my analysis, I am finding that even when I ask DAX to sum across all brands, I am getting different values for each brand (resulting in my total %s being off and adding to 100). How can I ensure that the denominator is truly summing across all brands and chains (customers) in the given time period, and the numerator is summing across just the selected chain for the time period of that particular bar, for just the brand represented by that segment of the bar?
Current Code is:
Total Sales in Period = CALCULATE(SUM(f_RAD[9L Cases]), ALL(d_Brand[BrandName]), ALL(f_RAD[Chain Parent]))
Percent of Total Business (by Volume) v2 =
DIVIDE(
SUMX('f_RAD',[9L Cases]), [Total Sales in Period]
)
Thank you in advance for any help you can provide!
Best,
Hannah
