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?