Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |