Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

FILTER does not affect segmentation

Good, I need a FILTER that is not affected when filtering by a segmentation. In the following example, you would need that if you filter on a segmentation [Day] by Monday or Tuesday, the denomina...
  • Fowmy's avatar
    Fowmy
    5 years ago

    Try one of these:

    Ratio Distance 2 =
DIVIDE (
    SUM ( 'T_Datos_GPS'[Last Distance(km)] ),
    CALCULATE (
        AVERAGE ( 'T_Datos_GPS'[Distance (km)] ),
        FILTER ( 'T_Día_semana', ' T_Día_semana'[Día] IN  {"Sunday","Monday" )
    )
)


    or

    Ratio Distance 2 =
DIVIDE (
    SUM ( 'T_Datos_GPS'[Last Distance(km)] ),
    CALCULATE (
        AVERAGE ( 'T_Datos_GPS'[Distance (km)] ),
        FILTER ( ALL('T_Día_semana'), ' T_Día_semana'[Día] IN  {"Sunday","Monday" )
    )
)
Fowmy's avatar
Fowmy
Super User
5 years ago

Try one of these:

Ratio Distance 2 =
DIVIDE (
    SUM ( 'T_Datos_GPS'[Last Distance(km)] ),
    CALCULATE (
        AVERAGE ( 'T_Datos_GPS'[Distance (km)] ),
        FILTER ( 'T_Día_semana', ' T_Día_semana'[Día] IN  {"Sunday","Monday" )
    )
)


or

Ratio Distance 2 =
DIVIDE (
    SUM ( 'T_Datos_GPS'[Last Distance(km)] ),
    CALCULATE (
        AVERAGE ( 'T_Datos_GPS'[Distance (km)] ),
        FILTER ( ALL('T_Día_semana'), ' T_Día_semana'[Día] IN  {"Sunday","Monday" )
    )
)