Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
newhopepdx
Helper II
Helper II

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?

1 ACCEPTED SOLUTION
v-tianyich-msft
Community Support
Community Support

Hi @newhopepdx ,

 

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

vtianyichmsft_0-1721271789774.png

vtianyichmsft_1-1721271803501.png

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.

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-tianyich-msft
Community Support
Community Support

Hi @newhopepdx ,

 

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

vtianyichmsft_0-1721271789774.png

vtianyichmsft_1-1721271803501.png

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.

That's exactly what I was looking for. 

THANKS!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.