March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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?
Solved! Go to 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.
Hi,
Share some data to work with and show the expected result.
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.
That's exactly what I was looking for.
THANKS!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
89 | |
73 | |
62 |
User | Count |
---|---|
140 | |
121 | |
107 | |
99 | |
94 |