Forum Discussion

Lewa's avatar
Lewa
Icon for Helper I rankHelper I
8 years ago
Solved

Standalone Filter

Hi All!    How I can create a standalone filter?  In order to:  use it on all measures;  edit it once in one place.  Thx. 
Need Help
  • iamprajot's avatar
    iamprajot
    8 years ago
    It is not possible to create a Variable or Filtered Context and use it in multiple Measures instead, create a separate table filtered from the source data according to need and than use all the measures based on that table.
shebr's avatar
shebr
Icon for Resolver III rankResolver III
8 years ago

Hi Lewa

 

Is this so that you can set the slicer once and filter the whole report? You need report level slicers I believe. Watch this short video and let me know how you get on. https://youtu.be/CuT5Wtld_iU

 

 

Thanks

 

shebr

Lewa's avatar
Lewa
Icon for Helper I rankHelper I
8 years ago

Hi, shebr 

 

Nope, I talking about standalone filter code. 

For example: 

1. Many aggregate measures have a one filter: 

 

VAR FILTER1 = FILTER(VALUES(Table1); USERPRINCIPALNAME() = Table1[EMail])

2. I want to edit it 

3. I have to edit every measure 

 

I want to edit it once in one place. The problem is, I can't keep a standalone filter on an measure. 

 

  • iamprajot's avatar
    iamprajot
    Icon for Responsive Resident rankResponsive Resident
    8 years ago
    It is not possible to create a Variable or Filtered Context and use it in multiple Measures instead, create a separate table filtered from the source data according to need and than use all the measures based on that table.