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