- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Don't filter a Card in a drillthrough page
Hi everyone,
I am working on a project and I want to add a scorecard with an overall average of a survey. I want this card to be a reference for the page so that people can see the values in the drill through and compare it to the overall average.
In other words, I want to add a scorecard to this drill through page that doesn't filter with the drill through page. It would show the overall average instead of the average of the group that the user drilled through to.
I hope that makes sense, I appreciate the time and help from the community.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for responding, this didn't end up working but I came up with my own solution. I created a column that didn't have the detailed information that the last column did which meant that no matter what the drill through couldn't remove that higher level information I wanted. Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You need the measures on the card to remove the filters from the drillthrough
I.e
Calculate(
[Some measure]
, removefilters( drillthroughTable[column] )
, removefilters( another drillthroughTable[column])
)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for responding, this didn't end up working but I came up with my own solution. I created a column that didn't have the detailed information that the last column did which meant that no matter what the drill through couldn't remove that higher level information I wanted. Thanks again.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
09-03-2024 03:39 PM | |||
Anonymous
| 07-19-2018 03:03 PM | ||
08-02-2024 08:57 AM | |||
10-21-2024 12:33 PM | |||
09-17-2024 09:58 AM |
User | Count |
---|---|
88 | |
74 | |
63 | |
48 | |
36 |
User | Count |
---|---|
116 | |
86 | |
80 | |
59 | |
39 |