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

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'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