SELECTEDVALUE returns blank in column but is populated when added to card

[DC_ZA]

I have a table in PowerBI with a monthstring column (YYYYMM), I use this in a filter so the datatype is set as 'text', I created a measure using SELECTEDVALUE to return the monthstring that is selected in the filter. When I add this measure in a card, it returns the correct value and also changes as I change the selection.

X_SelectedMonthstring = SELECTEDVALUE(Dim_FilterMonthString[Monthstring])

The problem comes in when I want to use this measure in another column, say for instance to add a column with a flag (1 or 0) to indicate the selected monthstring in a table, it is only returning 1 for all fields.

Measure: X_SelectedMonthstring = SELECTEDVALUE(Dim_FilterMonthString[Monthstring])

 

Column: X_MonthString_Flag = IF(Dim_FilterMonthString[MonthString]=[X_SelectedMonthstring],1,0)

Column: X_TestString = SELECTEDVALUE(Dim_FilterMonthString[MonthString])

If I change the column formula to be a fixed value I get the desired results:

Column: X_MonthString_Flag = IF(Dim_FilterMonthString[MonthString]="202106",1,0)

[ryan_mayu · Accepted solution]

@DC_ZA 

i don't think the slicer can affect a calculated column. You need to have a measure solution

[DC_ZA]

@ryan_mayu Thank you, I skipped using the flag column all together and used my measure directly in my second measure and it worked. 

[ryan_mayu]

you are welcome