Cannot filter by date

[AlejandroPCar]

Hi!

I have an strange issue. I cant filter by date this formula even if the date is in the same data table. Hope you can help me.

Here is my pbix file: https://1drv.ms/u/s!AtTnrgPUQzQCsShzLKIsUmF-eQjZ

Thank you very much. 

[v-jiascu-msft · Accepted solution]

Hi @AlejandroPCar,

You made the filter of date invalid by ALLEXCEPT in the formula of "Indice Junio Clase". That's the cause. You can add one part like the blue part to activate it.

Indice Junio Clase =
CALCULATE (
    SUM ( 'Prueba Junio'[Calculo Indice Clase] ),
    ALLEXCEPT ( 'Prueba Junio', 'Prueba Junio'[Clase], 'Prueba Junio'[Fecha] )
)

Note: Please be aware of your privacy of data.

Best Regards,

Dale

[AlejandroPCar]

@v-jiascu-msft

Thank you very much.