Summing total number of true vales per month, based on no. months filtered

[NickIT91]

Hi all,

I have a table that returns true for each month a client is active or inactive in a given month/period (if a value of true is not returned, then the client has dropped off completely). 

Is there a DAX formula where I can sum up the number times a value of true has been returned. E.g. if looking at the first 6 months of 2020, and a client has True appear 6 times, it will show 6 if the year 2020 is filtered

Many thanks

[amitchandak]

@NickIT91 , with the client this will 1 active for 6 months

Rolling 6= if(CALCULATE(sumX(values('Date'[Month year]),if([Active],1,0)),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH)) =6, 1,0)