Accumulated for a large data set

[gsamaral77]

Hello, I hope everybody is okay

I need to create a Pareto chart that shows the equipment that fails the most

I know the steps to do that, creat de measure that count the fails, ranking, accumulated and % accumulated but the data set is very large, the equipment list has about 25000 lines so when a try to create de Pareto's chart show de error message that there is not enough memory. Someone can help me please?

Equipment's Table:

Note's table

They are connected by equipment's tag. The note's table contains the registers of fails.

Measures:

I believe the problem is filter All in the measure "Qtd de avarias acc", because return all the lines of the Equipment's table but I have no ideia how to fixe that's

[lbendlin]

You are on the right track.  To reduce cardinality you will want to group your data by equipment and then calculate the number of incidents.  Use SUMMARIZE or GROUPBY.