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     ...
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

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