Calculate sum without filters

ChrisDurham — Fri, 13 May 2022 09:43:31 GMT

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

Re: Calculate sum without filters

Tanushree_Kapse — Fri, 13 May 2022 09:55:54 GMT

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

topic Calculate sum without filters in DAX Commands and Tips

Calculate sum without filters

Re: Calculate sum without filters