Forum Discussion

newhopepdx's avatar
newhopepdx
Icon for Resolver I rankResolver I
2 years ago
Solved

Slicer to remove donor from matrix

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?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      newhopepdx
      Icon for Resolver I rankResolver I
      2 years ago

      That's exactly what I was looking for. 

      THANKS!