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.
Really struggling with this one. I'm trying to do a comparison of charitable giving in two different geographic regions. User can choose the two regions to compare with two different slicers. This is easy when the same metrics are in standalone visuals because I can just use the Edit Interactions options.
However, I also want to display these metrics in the same visual (a bar chart) beside one another, which means I need to create two measures.
Here's what I have tried so far.
Two columns for filtering in slicers - Chosen Region and Comparison Region
ChosenRegionTotal = CALCULATE ( SUM ( 'Transactions'[Total Spent] ), ALLEXCEPT ('Accounts','Accounts'[Chosen Region]) )
When I place this in a card, it only works if I turn off the interaction from the Comparison Region filter. This is not an option because I want to display this in a bar chart alongside the ComparisonRegionTotal measure (same thing but ignoring the Chosen Region column filter). If it's an ALLEXCEPT, shouldn't ignore the other column's filtering?
I'm hoping it's because I'm just fundamentally confused about ALL and ALLEXCEPT, but I feel like there has to be a solution.
Data is sensitive so I can't supply a report.
Solved! Go to Solution.
Seems you're correct, although I still don't understand why ALL or ALLEXCEPT won't work in this scenario.
I was able to get the result I wanted, but only by duplicating the table.
No, it's not possible. When you put both measures into same chart visual, they must take all slicers selection in calculation. We can't have one measure take one slicer, and make other measure take another slicer.
Regards,
Seems you're correct, although I still don't understand why ALL or ALLEXCEPT won't work in this scenario.
I was able to get the result I wanted, but only by duplicating the table.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |