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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ChrisDurham
Frequent Visitor

Calculate sum without filters

Good Mornign all,

       I am trying to calculate the total value of a project excluding all filters. My data structure is as follows :-

 

     Parent Project  ->  Child Project   -> Prices

 

      I want to have a total value for the Parent Project, ignoring all filters placed on both the Child Project and the Prices tables. I have tried using CALCULATE with ALLEXCEPT but I can;t get it to work properly. Should I create a Child Total first and then sum that for the Parent Total? 

 

Thanks For Any Help

Chris

1 ACCEPTED SOLUTION
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @ChrisDurham ,

 

Create a measure with the ALL function to ignore the filters:

Measure= CALCULATE(SUM[Column], ALL(Table))

 

This would give you the total sum ignoring all the filters that've been applied.

 

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks

View solution in original post

1 REPLY 1
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @ChrisDurham ,

 

Create a measure with the ALL function to ignore the filters:

Measure= CALCULATE(SUM[Column], ALL(Table))

 

This would give you the total sum ignoring all the filters that've been applied.

 

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.