Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
21 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |