Maximum allowed size of 1000000 rows
Hi, I have to prepare the following Lag report In above case, in January 2022,13413 number of accounts opened. In following months there is a count of A/cs which are not closed for eg As on 28 feb 22, 3 accounts were closed so the no. of accounts active are 13410. To acheive this I have 3 measures Account opened in Cust Dim = Var monthafter = SELECTEDVALUE(Series[Series]) Var Currentfirstopeningmonth =SELECTEDVALUE('Customer Detail'[Lag_opening date]) return CALCULATE( DISTINCTCOUNT('Customer Detail'[ACNTS_INTERNAL_ACNUM]), FILTER('Customer Detail', EOMONTH('Customer Detail'[ACNTS_OPENING_DATE],0)=EOMONTH(Currentfirstopeningmonth,monthafter) ) ) Account closed in Cust dim = var as_on_date = SELECTEDVALUE(Date_DIM[AS_ON_DATE]) return CALCULATE( DISTINCTCOUNT('Customer Detail'[ACNTS_INTERNAL_ACNUM]),'Customer Detail'[ACNTS_CLOSURE_DATE]<>BLANK(), FILTER('Customer Detail', EOMONTH('Customer Detail'[ACNTS_CLOSURE_DATE],0)<=EOMONTH(as_on_date,0) )) lag reort= Var A = SELECTEDVALUE(Date_DIM[AS_ON_DATE]) return CALCULATE([Account opened in Cust Dim]-[Account closed in Cust dim], filter( 'Customer Detail', SELECTEDVALUE('Customer Detail'[Lag_opening date])<=A)) In Matrix table Rows= Account Opening Month and Year (Customer Dim) Columns = As on Date (Date Dim Table) Values = Lag Report measure In above case,I have filtered only one product code hence the measure is running properly but when I use all the products it is giving the following error How can I solve this error?
