DAX - Average by sum of different values

[Vialle_Diego]

Hello, I need to find the average of the column [Delivery Time] by the distinct sum of the column [Index Count]:

Medida = CALCULATE(
    AVERAGEX(
        VALUES(dCalendario[Data]),
    CALCULATE(DISTINCTCOUNT(fPedidos[Índice])
    )))

[amitchandak]

@Vialle_Diego , that depends on visual column

Medida = CALCULATE(
AVERAGEX(
VALUES(dCalendario[State]),
CALCULATE(DISTINCTCOUNT(fPedidos[Índice])
)))

[Vialle_Diego · Accepted solution]

I found the solution, thanks.

Média dias de entrega = 
VAR Qnt_Entregas =
    DISTINCTCOUNT ( fPedidos[Índice] )
VAR Soma_Dias_Entrega =
    SUMX (
        VALUES ( fPedidos[Índice] ),
        CALCULATE ( AVERAGE ( fPedidos[Tempo de Entrega] ) )
    )
RETURN
    DIVIDE ( Soma_Dias_Entrega, Qnt_Entregas )