memory problems

[alsolok]

Hello everyone,

I have the problem the memory on my indicator.

this is my message error "There is insufficient memory to complete this operation. Try again later when there may be more memory available."

and this is my calculate indicator : 

CALCULATE([Nb person],FILTER('Dim Person','Dim Person'[fin_valid] < 'Dim Person'[date])).

My table person contains 25millions rows

Help me if there is another alternative.

[SpartaBI · Accepted solution]

@alsolok switch to:

CALCULATE(
	[Nb person],
	KEEPFILTERS(
		FILTER(
		ALL('Dim Person'[fin_valid],'Dim Person'[date]),
		'Dim Person'[fin_valid] < 'Dim Person'[date])
	)
)

Not sure if it's enough to solve your memory constraint, cause I don't know your model or what is this measure doing [Nb person] 🙂 but anyway the performance of the version I sent is better