Forum Discussion
How to filter multiple measures for top/mid/low range based on Names selected in 3 different slicers
Hello! I am trying to have a table with opportunities and the value, but have 3 measures for Total ARR based on the selections made in the 3 different slicers. I made a simple report to show the idea...
It doesn't have to be 3 slicers, but I do need a way for the user to be able to select what they mark/filter as Top, Mid, and Low range, so I thought it was nessesary. Open to ideas. It doesn't even have to have the duplicated Name columns, that was just the way I was trying to get it to work.
Here is the sample data I was posting screen shots of in original post.
EDIT: I don't think this table is working right. I just did "Opp ID" 1-40, "Name" Opp 1-Opp 40, duplicated name for "Name 2" and "Name 3", and "ARR" is just a random number between 200,000-1,000,000.
| Opp ID | Name | Name 2 | Name 3 | ARR |
| 1 | Opp 1 | Opp 1 | Opp 1 | 603157 |
| 2 | Opp 2 | Opp 2 | Opp 2 | 861819 |
| 3 | Opp 3 | Opp 3 | Opp 3 | 218570 |
| 4 | Opp 4 | Opp 4 | Opp 4 | 389878 |
| 5 | Opp 5 | Opp 5 | Opp 5 | 379003 |
| 6 | Opp 6 | Opp 6 | Opp 6 | 697019 |
| 7 | Opp 7 | Opp 7 | Opp 7 | 325887 |
| 8 | Opp 8 | Opp 8 | Opp 8 | 555303 |
| 9 | Opp 9 | Opp 9 | Opp 9 | 164829 |
| 10 | Opp 10 | Opp 10 | Opp 10 | 29786 |
| 11 | Opp 11 | Opp 11 | Opp 11 | 417037 |
| 12 | Opp 12 | Opp 12 | Opp 12 | 586612 |
| 13 | Opp 13 | Opp 13 | Opp 13 | 849123 |
| 14 | Opp 14 | Opp 14 | Opp 14 | 115247 |
| 15 | Opp 15 | Opp 15 | Opp 15 | 992911 |
| 16 | Opp 16 | Opp 16 | Opp 16 | 713453 |
| 17 | Opp 17 | Opp 17 | Opp 17 | 297521 |
| 18 | Opp 18 | Opp 18 | Opp 18 | 621365 |
| 19 | Opp 19 | Opp 19 | Opp 19 | 957907 |
| 20 | Opp 20 | Opp 20 | Opp 20 | 712479 |
| 21 | Opp 21 | Opp 21 | Opp 21 | 549085 |
| 22 | Opp 22 | Opp 22 | Opp 22 | 778902 |
| 23 | Opp 23 | Opp 23 | Opp 23 | 936451 |
| 24 | Opp 24 | Opp 24 | Opp 24 | 596444 |
| 25 | Opp 25 | Opp 25 | Opp 25 | 195701 |
| 26 | Opp 26 | Opp 26 | Opp 26 | 365824 |
| 27 | Opp 27 | Opp 27 | Opp 27 | 365482 |
| 28 | Opp 28 | Opp 28 | Opp 28 | 186828 |
| 29 | Opp 29 | Opp 29 | Opp 29 | 381082 |
| 30 | Opp 30 | Opp 30 | Opp 30 | 614462 |
| 31 | Opp 31 | Opp 31 | Opp 31 | 991920 |
| 32 | Opp 32 | Opp 32 | Opp 32 | 936098 |
| 33 | Opp 33 | Opp 33 | Opp 33 | 240992 |
| 34 | Opp 34 | Opp 34 | Opp 34 | 885260 |
| 35 | Opp 35 | Opp 35 | Opp 35 | 854604 |
| 36 | Opp 36 | Opp 36 | Opp 36 | 501579 |
| 37 | Opp 37 | Opp 37 | Opp 37 | 909026 |
| 38 | Opp 38 | Opp 38 | Opp 38 | 790102 |
| 39 | Opp 39 | Opp 39 | Opp 39 | 720204 |
| 40 | Opp 40 | Opp 40 | Opp 40 | 399962 |