IsFiltered() does not work as a column

[DroiD03]

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.

[D_Khandelwal]

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 

[v-juanli-msft · Accepted solution]

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