IF statement with a column

[Alicetemitope]

Hi Everyone,
I am currently working on a report and I want to display results of a measure for a select few of the users based on their user principal name or email address. 

For example using table below:
Measure =
VAR Result = sumofacolumn

Return If(view Result = "Yes", sumofacolumn, "Result not available to user")

The above is what I am hoping to replicate using IF statement in DAX but it seems the IF statement only works with a calculated column. I want to use it in a measure. 

Please how can I go about this? Thank you.

USER Principal Name	View Result
kjhdviugdhjd@gmail.com	Yes
fiohbzbghre8uj@yahoo.com	No
ldkjubfeoiü@gmail.com	Yes
hkdjjbkvbhdfiuofdsm@gmail.com	No

[QwertyMartijn]

Hi, try to use SELECTEDVALUE(View Result) in your measure. That might fix your reference to the column.