Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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"
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"
That's it!!! Thank you! Your solution also helped me with another similar issue. Very much appreciated!
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |