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.
Go to Solution.
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
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!