Forum Discussion

DroiD03's avatar
DroiD03
Frequent Visitor
7 years ago
Solved

IsFiltered() does not work as a column

Hi,

 

I am trying to achieve a simple functionality using ISFILTERED() DAX function. When I use it in calculated measure it works but when I am creating a Calculated column it doesn't.

T_C = IF(ISFILTERED('Dim Date'[MS Fiscal Year Name]),1,0)  <-Column code

T_M = IF(ISFILTERED('Dim Date'[MS Fiscal Year Name]),1,0)  <-Measure code

 

 

 

 

 

 

 

 

 

 

Why it is like that? Can someone explain please.

 

 

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi DroiD03

    You can't filter calculated columns by slicers.

    Calculated columns are only calculated once - when you load/refresh your data model. After that, they contain fixed, static values that can not respond to slicers.

    To achieve your goal, you will need to use measures, not calculated columns. 

     

    See differences below

    calculated column VS measures

     

    Best Regards

    Maggie

     

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi DroiD03

    You can't filter calculated columns by slicers.

    Calculated columns are only calculated once - when you load/refresh your data model. After that, they contain fixed, static values that can not respond to slicers.

    To achieve your goal, you will need to use measures, not calculated columns. 

     

    See differences below

    calculated column VS measures

     

    Best Regards

    Maggie