Hello, I have a table called filter and I have another table of records, this table has a slice which filters depending on the data in the filter table. I’m using a formula that counts the records of that slice filtered like this: count(filtered table[ID]), but this formula keeps counting the records of the original table and not the filtered table. what can be the error ?. the filtered table works perfectly, but when using the formula it has no effect.

It appears you’re attempting your count in the app formula for the TOTAL REGISTROS virtual column of the FILTRO CARTERA slice. The expression, count(REPORTE FILTRADO[Numero de Prestamo]), references the REPORTE FILTRADO slices, which itself makes use of the FILTRO CARTERA slice. This is a circular reference: you’re asking FILTRO CARTERA to count rows of a slice that won’t be established until FILTRO CARTERA has been applied. FILTRO CARTERA has to be completely computed before it can be used. When TOTAL REGISTROS is computed, REPORTE FILTRADO has not yet been filtered because FILTRO CARTERA is itself still being computed.

My recommendation is to move TOTAL REGISTROS to a table that isn’t involved in the generation of REPORTE FILTRADO.

WOW that’s great!, i used the last code you sent and create a new table to see the “TOTAL REGISTROS” in fact my application works faster. I’m really grateful for your help. This community is the best! thank you very very much.