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
bundipapa
Frequent Visitor

Total a value ignoring TOPN filter

Hello,


I have to create a view of the TOP 5 products sold with applicable GEO and other filters/slicers (product group and similar - only using GEO in the example). My problem is with showing, what portion the TOP 5 products represent of the total revenue when the filters are applied. I need a calculation, that would adjust based on the slicers, but would ignore the TOPN filter setting and sum the revenue for all products for the given slicer setup.

bundipapa_0-1714562955872.png


For Total revnue here I have the function 

Total revenue = CALCULATE(sum(Sheet1[Revenue]),ALL(Sheet1))
If I select NA, the total revenue remains the same, although NA is only 21M of the total of 61M.
bundipapa_1-1714563058848.png

 



1 REPLY 1
DataNinja777
Super User
Super User

Hi @bundipapa ,

 

What about allexcepting GEO field so that the GEO filter will be applied to your Total revenue measure?  

DataNinja777_0-1714571511592.png

Best regards,

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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