Remove Values From Visual Based On Slicer Selection

[emmetk]

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?

[v-lili6-msft]

hi  @emmetk 

You could just create a simple measure

Measure=CALCULATE( SUM(Count) ) 

Do not add "+0" in this formula.

Regards,

Lin

[VasTg]

@emmetk 

Based on your sample data, aren't you suppose to get 150 for FR?