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 estat...
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.

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!