Entender KEEPFILTERS

luis_garcia — Thu, 18 May 2023 16:38:55 GMT

Hola:

Tengo una tabla sencilla y quiero entender como funciona KEEPFILTERS para hacer % de variación y no entiendo porque las dos primeras Medidas NO funcionan como quiero:

Las 2 medidas en ROJO no funcionan 'bien' (no muestran datos en la oleada que no le corresponde), y la medida en Verde si, pero me obliga a tener una tabla auxiliar. La única diferencia es la condición del filtro (zona azul)

¿Estoy haciendo algo mal?

Un saludo

Re: Entender KEEPFILTERS

Anonymous — Tue, 23 May 2023 07:56:31 GMT

Hi luis_garcia ,

I think this is not an issue. I can reproduce this on myside.

As far as I know, I think the difference should be casued by that [Columna] in SELECTEDVALUE() comes from the unrelated Oleadas table.

Measure [KeepFilter_Oleada1/2] use keepfilter equal to determind Oleada type, so your measure will return correct result in that Oleada type.

There is no relationship between two tables, so measure [KeepFilter_OleadaX] will return result in all Oleada type.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Entender KEEPFILTERS in DAX Commands and Tips

Entender KEEPFILTERS

Re: Entender KEEPFILTERS