if condition dont work using CALCULATE

yanivl The issue with your Msg_MainYehida column likely stems from the fact that CntSelectMainYD is a measure, not a column. Measures are calculated dynamically based on the context of the report, and they cannot be directly referenced in calculated columns

To resolve this, you should use a measure for Msg_MainYehida instead of a calculated column

DAX
Msg_MainYehida =
IF(
[CntSelectMainYD] = 1,
SELECTEDVALUE(T_YD[MainYD_Desc]),
"NOT ONE!"
)

Your issue is because you used a calculated column — slicer filters don’t affect it. ✅ Use measures instead:

CntSelectMainYD =
COUNTROWS ( ALLSELECTED ( T_YD[MainYD_Desc] ) )

Msg_MainYehida =
IF ( [CntSelectMainYD] = 1,
SELECTEDVALUE ( T_YD[MainYD_Desc] ),
"NOT ONE!" )

Hi yanivl ,

The issue is due to mixing a measure and a column. CntSelectMainYD is a measure, so referencing it as T_YD[CntSelectMainYD] is incorrect. Additionally, using a calculated column won’t work since the logic relies on filter context.

To resolve this, create a new measure as follows :

Msg_MainYehida =
IF (
    [CntSelectMainYD] = 1,
    SELECTEDVALUE ( T_YD[MainYD_Desc], "NOT ONE!" ),
    "NOT ONE!"
)

[CntSelectMainYD] is correctly used as a measure. SELECTEDVALUE returns the single value of MainYD_Desc if selected, or "NOT ONE!" otherwise. This approach ensures the message updates dynamically based on slicer or filter selections.