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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
yellow43
Helper I
Helper I

Apply filter for % and keep original %

Hello,

 

I have a situation where I have removed filters and I want to apply a filter where it will show only the countries that have a % greater than x% and are only in the geo AFR?

 

Because if I apply a Visual-level Filters on Dashboad Report, it will apply to the geo level, and I want to apply to country Level.

Whenever I apply a filter the % will be redefined and I want to keep the original percentage will all geos and all countries.

 

Sould not change the %GT with filters applied.

yellow43_0-1667578151636.png

 

Apply filter for % greater than 5% for AFR it should only show CN and DZ with the original percentage. 

yellow43_1-1667578217654.png

 Dax Function:

Total Sales = CALCULATE(SUM(dados[Sales]); REMOVEFILTERS(dados[Country];dados[Geo]))
  

Thank you in advance.

1 REPLY 1
daXtreme
Solution Sage
Solution Sage

If you've not got any answers since Friday... what does it mean? Well, that means the question is not clear. Please rephrase. This can help you: How to Get Your Question Answered Quickly (powerbi.com)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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