Forum Discussion
Remove Values From Visual Based On Slicer Selection
Hello,
I need help hiding values from a visual based on a slicer selection instead of simply zeroing them out. I've provided some examples of my data, results, and desired results below. Any help would be appreciated!
I have multiple tables detailing various country level data. In order to simplify filtering across each table, I've employed a handful of reference tables. I've included examples of each below:
| Example Data Table | ||
| Country | Category | Count |
| US | A | 150 |
| CA | A | 175 |
| DE | A | 125 |
| FR | A | 100 |
| CA | A | 50 |
| DE | A | 75 |
| US | A | 100 |
| US | B | 175 |
| CA | B | 125 |
| DE | B | 100 |
| FR | B | 50 |
| Example Filter Table | ||
| Country | Category | Type |
| US | A | 1 |
| CA | A | 1 |
| DE | A | 1 |
| FR | A | 0 |
| US | B | 0 |
| CA | B | 0 |
| DE | B | 1 |
| FR | B | 1 |
In this case, these tables have a relationship based on the Country fields with one other reference table (composed of only Country values) between them (in order to maintain One to Many relationships). However, whenever I filter on Type, I don't get the results I am looking for.
Results, Filter on Type = 1
| US | 250 |
| CA | 225 |
| DE | 200 |
| FR | 0 |
Desired Results, Filter on Type = 1
| US | 250 |
| CA | 225 |
| DE | 200 |
The only difference between these results is that FR has been completely removed from the table. How can I get these values removed entirely from the table using slicers only?
2 Replies
hi emmetk
You could just create a simple measure
Measure=CALCULATE( SUM(Count) )
Do not add "+0" in this formula.
Regards,
Lin
