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

     

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