Forum Discussion
Filter a value with some dropdown
Hi Anonymous
All : Calculate All Values independent of filters.
AllSelected : Calculate All Values of Selected data. Any external filter that applied will be excluded from it.
AllExcept : Calculate All Values in selection independent of All filters except you define in this context.
https://docs.microsoft.com/en-us/dax/all-function-dax
https://docs.microsoft.com/en-us/dax/allcrossfiltered-function-dax
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
I have attached a sample about the three DAX , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
i have this kind of datas :
with this dropdown :
and i want my 3 last dropdown to not filter my 3rd column for 1 measure but still do it in the visual.
For example i have now "reste : 222" for 2020
If I select data in "Commune" (3rd dropdown) and my "reste" change i want to see it in my tab but i don't want the value 222 to change for a measure.
Don't know if it's clearer ?
I was thinking about making a measure or calculated column or I don't know what, which filter my column "reste" without taking my dropdowns "commune, pressoir, slicer_livreur" for the filtering.
I use after this new measure for another calcul which allow me to show the value filtered in my tab but don't use this value for the calculation