Switch Measure

[SirBI]

I have a table "tableA" Within this table I have a column source with "Y" and "N" values. 

I need to create a Measure (not calcuated column) to create a mapping. 

Y = Yes

N = No. 

I'm trying the switch statement but my column does not show.

switch(tableaA.source,"Y","Yes", "No"). What am I doing wrong? 

[amitchandak · Accepted solution]

@SirBI , In case of measure you can use aggregated columns

example

switch(Max(tableaA[source]),

"Y","Yes",

"No")