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

5 Replies

  • 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