dax allselected

[Arnoh]

Hi,

I made a measure with allselected. Now i would like to exclude "one" filter apllied on this report page. 

Thanx for any help.

[Arnoh]

Hi,

This is my current dax measure

verschil_vorig jaar v2 = 
var cumulatiefvorigjaar =

CALCULATE(-SUM(zmutatie[bedrag]);
FILTER(ALLSELECTED(zmutatie);zmutatie[boekjaar]+1=max(zmutatie[boekjaar]) && 
zmutatie[regeltype]<>16&&zmutatie[Week_iso]<=MAX(zmutatie[Week_iso])))

return
([Cumulatiefzmutatie]-cumulatiefvorigjaar)/cumulatiefvorigjaar

I need te clear te applied filter on: ;  z_datum_tabel[jaar_selectie] 

[v-alq-msft]

Hi, @Arnoh 

Based on my research, you may try the following measure.

verschil_vorig jaar v2 =
VAR cumulatiefvorigjaar =
    CALCULATE (
        - SUM ( zmutatie[bedrag] );
        ALL ( 'z_datum_tabel'[jaar_selectie] );
        FILTER (
            ALLSELECTED ( zmutatie );
            zmutatie[boekjaar] + 1
                = MAX ( zmutatie[boekjaar] )
                && zmutatie[regeltype] <> 16
                && zmutatie[Week_iso] <= MAX ( zmutatie[Week_iso] )
        )
    )
RETURN
    ( [Cumulatiefzmutatie] - cumulatiefvorigjaar ) / cumulatiefvorigjaar

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arnoh]

Hi Allen,

Thanx for your reaction. I did not solve the issue. 

I made an other function withe allexept but the disadvatage of it is that when i add another filter i need te adjust the measure as well.

Do you have any other suggestions.

Thanx

[Greg_Deckler]

Generally you do that with ALL, ALLEXCEPT or REMOVEFILTERS. Would help to see sample data and formula. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[amitchandak]

@Arnoh 

You can use all(Table[ColumnName]) or removefilters

https://docs.microsoft.com/en-us/dax/removefilters-function-dax