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
Hi Anonymous
How has your problem progressed so far ? If you select data in "Commune" (3rd dropdown) , will the value of "reste" change ?
Since I am not very clear about your formula for calculating “reste”, there is no way to determine the specific reason. Can you provide your pbix file ? Maybe this will help us deal with the problem better .
Best Regard
Community Support Team _ Ailsa Tao
Hi !
It's complicated for me to give the pbix file because of the right in my society, so i understand that it's complicated for you to help me fix my problem.
So maybe can you just give me some clues about filtering and i will try my best with that.
If you have good documentation about the filter like ALL which allow to avoid some other filter it would be great because I'm not sure to have a good understanding of it.
Thank you very much for your time !