Slicer to remove donor from matrix

[newhopepdx]

Displaying a matrix of donors (rows) by funds donated to and their % of total donated dollars. 
Sliced by date range and region.

There are times when a donor has made an unusal gift (e.g., an estate gift) that skews them as a (regular) high donor, and reduces everyone else's % of total.

Is there a way to set up a slicer of donors where the one(s) selected are EXCLUDED from the matrix?

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[Anonymous · Accepted solution]

Hi @newhopepdx ,

I made simple samples and you can check the results below:

Measure = var _select = VALUES('Table 2'[Name])
RETURN IF(ISFILTERED('Table 2'[Name]),CALCULATE(SUM('Table'[Cost]),FILTER('Table',Not VALUES('Table'[Name]) IN _select)),SUM('Table'[Cost]))

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[newhopepdx]

That's exactly what I was looking for. 

THANKS!