Forum Discussion

ChrisDurham's avatar
ChrisDurham
Frequent Visitor
4 years ago
Solved

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

ALLEXCEPT
CALCULATE
sum
  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    4 years ago

    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

1 Reply

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    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