Help with IF function

[casea14]

Hi There!

I have two calculated measures  -- one that correctly calculates the Avg Market Turn % for Even Years and another that correctly calculates the Avg Market Turn % for Odd Years.

But now I would like a single measure that calculates the same thing. I was thinking something like the following IF function with the above Even Year calculation as the ResultIfTrue part of the IF function and the above Odd Year calculation as the ResultIfFalse part of the IF function...... but then I get the below error message. (excuse the bad DAX formatting)

ERROR: "A single value for column 'E/O' in table 'Dates_Key' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result"

Can anyone help me with this or offer any workarounds? Thank you!

[Zubair_Muhammad · Accepted solution]

Hi @casea14

At the beginning of your formula, use SELECTEDVALUE

i.e. replace   IF(Dates_Key[E/O]="Even"

with

IF(selectedvalue(Dates_Key[E/O])="Even"

[casea14]

Hi @Zubair_Muhammad

That's it!!! Thank you! Your solution also helped me with another similar issue. Very much appreciated!