Forum Discussion
itsmeanuj
Helper IV
Helper IVExclude month from Total when sum is 0
Hi, I have a DAX formula below where I want to include a condition that if [Sum_of_Actuals] for any month is 0, then exclude that month from the total calculation. FY_IP_DIff = VAR __table...
andhiii079845
Solution Sage
Solution SagePerhaps in this way?
VAR __table = SUMMARIZE(FILTER('2023 Data',[Month],[Sum_of_Actuals]<>0),"__value", abs([Sum_of_Actuals]-[Sum_of_IP]))