- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Summing Multiple Visual Slicers
I'm not sure this is possible and am open to other solutions.......but I am trying to make a report that allows management to select how many people will work on each of our programs. I have how each of those decisions will affect the goals of each team. (Example: If you put 3 people on Program A, you will meet all goals but if you drop it to 2 people, you will only hit 2 of 3 goals.) Because of this, I have to have all the program's data on different tabs and have a different slicer for each program (as the number of employees on one program will not effect the goals of a different program.) What I need to accomplish (and can't figure out how) is to notify management when they have "placed" all employees with a program. Ideally, I want to just sum the number selected on each of my slicers and have something turn green when they all sum to 52 employees. But I can't find a way to sum the number selected in a slicer. Again, I'm open to any solution that will quickly show they have accounted for all employees without counting too many. Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should be able to use MAX or SELECTEDVALUE to get the number out of each slicer.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should be able to use MAX or SELECTEDVALUE to get the number out of each slicer.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was able to use SELECTEDVALUE and just add them all together. This is PERFECT!!!! Thank you!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-01-2024 07:56 PM | |||
10-21-2024 07:27 AM | |||
04-17-2024 02:01 PM | |||
08-21-2024 08:02 AM | |||
11-06-2024 12:13 PM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |