Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to 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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |