Reply
Unkown_Sam
New Member
Partially syndicated - Outbound

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. 

 

 

1 ACCEPTED SOLUTION

Syndicated - Outbound

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. 

View solution in original post

2 REPLIES 2
Deku
Solution Supplier
Solution Supplier

Syndicated - Outbound

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

Syndicated - Outbound

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. 

avatar user

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 FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)