Mysterious behavior of the "Month" field with ALLSELECTED, ALL, etc

[josempomares]

How is it possible that the “Month” field cannot be affected by ALLSELECTED (nor by ALL, REMOVEFILTERS..)? As seen in the images, the rest of the fields in dimCalendario and dimProductos (e.j.) work as expected. ¡¡¡The “Month” field cannot be inhibited from filtering in the visual objects!!!.     Why???     ??¿?¿?¿?¿??¿?¿?¿?¿

[OwenAuger · Accepted solution]

Hi @josempomares 

My guess is that dimCalendario[nombreMes] is set to "sort by" dimCalendario[numMes].

If so, you need to remove filters on both of these columns in order to effectively remove filters on nombreMes.

See these articles:

https://www.sqlbi.com/articles/side-effects-in-dax-of-the-sort-by-column-setting/

https://www.sqlbi.com/blog/marco/2018/05/04/removing-column-filter-in-power-bi-when-sort-by-column-i...

Regards

[josempomares]

Thanks so much!!!!!