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