Hi Guys im having a hard time to understand why my cumulative Formula doesn’t Work.
The dax code is not calculating accurate cumulative totals when i insert the second filter
My Code is this:
Var Activations = CALCULATE(COUNT(Activations[MSISDN]);FILTER(Activations;RELATED(‘Targeted Category’[Targeted Types])=“Activations”))
DATE ( YEAR ( MAX ( ‘Datetable’[Date] ) ); MONTH ( MAX ( ‘Datetable’[Date] ) ); 1 )
<= DATE ( YEAR ( TODAY () ); MONTH ( TODAY () ); 1 );
ALL ( Datetable[Date] );
‘Datetable’[Date] <= MAX ( ‘Datetable’[Date] )
&& ‘Datetable’[Date] >= DATE ( 2019; 6; 1 )
);FILTER ( Activations; ‘Activations’[Assigned Customer BN] = 1 )
If i remove the filter for assigned customer bn it will show correct results but not the desired ones.