Forum Discussion

Alicetemitope's avatar
Alicetemitope
Frequent Visitor
3 years ago

IF statement with a column

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 NameView Result
[email protected]Yes
[email protected]No
ldkjubfeoiü@gmail.comYes
[email protected]No

1 Reply

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