Forum Discussion
Solved
Comparing measure and column value
Hi all, I'm new to PBI and struggling to understand why this if statement isn't working. I want to check whether the selected filter value is present in another table (linked via a separate key...
Thanks for the replies from Chetan007 and HotChilli.
Hi ndj2212 ,
As HotChilli says, because calculated column are pre-calculated and stored, they do not react to dynamic changes in page filters or slicers. Calculated column remain the same no matter how you filter the data in your report.
So you should create a measure instead of a calculated column, for example:
Measure = IF(MAX([Node1])=[sel],"Y","N")Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
