Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Thank you in advance for any help you can provide!
Best,
Hannah
Hi there.
Would you mind posting a snapshot of your data model and the report you've generated so far? Also, it would be quite helpful if you posted a sketch (or something similar) of how it should work.
Thanks.
Best
Darek
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |