Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have this graph which compares the currently filtered % counts of users vs those of the population.
The measures are:
Unique User Count = Calculate(DISTINCTCOUNT(UserData[user_id]))
and
Population = CALCULATE([Unique User Count],ALLEXCEPT('UserData','Savings Bucket Orders'[Savings Buckets]))
I need to reproduce this kind of graph multiple times for different x-axis of interest, I was wondering if there was a way to have something like
Population = CALCULATE([Unique User Count],ALLEXCEPT('UserData','Columns_in_visual'))
which I can reuse in every graph instead of having to create a new measure for each of them.
All attempts I've tried remove everything in the filter context which isn't what I'm after.
Thanks!
@Tuame , I doubt you can make a dynamic list of columns like that as of now.
You can create an idea https://ideas.powerbi.com/ideas/
I imagined as much, but wanted to ask people who are smarter than me haha - I'll leave the thread open a bit longer in case someone has a smart idea but if not I'll mark as a solution. Thanks for your reply!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
8 |