Forum Discussion

Arnoh's avatar
Arnoh
Helper III
6 years ago

dax allselected

Hi,   I made a measure with allselected. Now i would like to exclude "one" filter apllied on this report page.    Thanx for any help.
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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's avatar
Arnoh
Helper III
6 years ago

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