Forum Discussion

luis_garcia's avatar
luis_garcia
Regular Visitor
3 years ago
Solved

Entender KEEPFILTERS

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 medida...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.