Forum Discussion

aashritsingh's avatar
aashritsingh
Icon for Helper I rankHelper I
2 years ago
Solved

ALLEXCEPT with external filters

We are trying to get an ALLEXCEPT measure working also accounting for external filters. In this example scenario, we want to remove ALL filters in the table EXCEPT the Year (Including all columns fr...
Need Help
Show and Tell
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    aashritsingh 

    allselected(fact_table) ,  values(dim_date[date])

     

     

    let me know if it works for you . 

     

     

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

aashritsingh 

 

allselected if the only function that returns the external slicer filters and get rid of the visual filters .

 

i m afraid there is no other way in DAX  (that i know of ) to be able to maintain the slicer filters while removing the visual filters .

 

 

if you have a starschema, maybe try to use allselected(fact_table) , 

 

let me know if it works for you . 

 

best regards

 

 

 

  • aashritsingh's avatar
    aashritsingh
    Icon for Helper I rankHelper I
    2 years ago

    Hello Daniel29195 

     

    I did try using ALLSELECT(Fact Table). Although, it maintain external filters, but, removes all the context filters from the table. We just want to keep the filters on DATE_DIM. Is there a way to maintain that or, add the DATE_DIM filter after ALLSELECT processing?

    • Daniel29195's avatar
      Daniel29195
      Icon for Community Champion rankCommunity Champion
      2 years ago

      aashritsingh 

      allselected(fact_table) ,  values(dim_date[date])

       

       

      let me know if it works for you . 

       

       

      • aashritsingh's avatar
        aashritsingh
        Icon for Helper I rankHelper I
        2 years ago

        Daniel29195 

         

        This solution has worked. Thank you for the help 🙂