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

     

D_Khandelwal's avatar
D_Khandelwal
Frequent Visitor
3 years ago

Hello DroiD03, v-juanli-msft 

 

Is the above thing possible now in march 2023 version of Power BI or is there any work around for this ??

 

Thanks,
Dinky