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.
My sample data looks like folllowing (original data has many rows):
Manager | Country | Assets |
a | UK | 20 |
b | US | 30 |
c | UK | 10 |
d | UK | 40 |
e | US | 50 |
I have a slicer for country on my page. Added a bar chart showing assets of each manager, with a visual level filter of top 2 managers by assets.
I am trying to create a measure for the market share using 'divide' where numerator changes as per the slicer and accounts the filter both while denominator stays to the total (in this case 150)
I have used the below formula but this is not accounting the top-2 filter:
@Anonymous please show me what you expecting to see, and what you are currently getting, its hard to visualise what you saying. its always best to show what you getting and what you want to get with visuals.
it might just be a case of changing this to to allselected rather than all
Proud to be a Super User!
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |