Filter a value with some dropdown

[loicbozon]

Hello,

I have some value with dropdown for a dynamic filtering.

But I have some probleme with 1 value when I filter with a precise dropdown. I don't want that dropdown to impact my value.
Then I ask myself this question : "How can I filter a value using some data but not all ?"

I have tried with ALLEXCEPT, ALL, ALLSELECTED but I don't have the result i want.

I hope you have a response for me.

Thanks in advance.

[v-yetao1-msft · Accepted solution]

Hi @loicbozon 

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

[loicbozon]

Many thanks for all of this.

[v-yetao1-msft]

Hi @loicbozon 

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

[loicbozon]

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 !

[smpa01]

@loicbozon  the ask is not clear, provide some samle data and expected output.

[loicbozon]

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 ?

[loicbozon]

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