FILTER does not affect segmentation

[Syndicate_Admin]

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 denominator does NOT become null.

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]="sunday"))

)

[Fowmy · Accepted solution]

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" )
    )
)