Calculate sum without filters

[ChrisDurham]

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

[Tanushree_Kapse · Accepted solution]

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