Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Best Regards
Maggie
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
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
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |