DAX in Power Pivot - Replacing -> SELECTEDVALUE

[Guinaba]

Hi guys,

Any suggestion on how I can replace SELECTEDVALUE on the expression below to be used in Power Pivot?

Week Product Group Accuracy % := 1 -
(
SUMX (
SUMMARIZE (
IBPData,
IBPData[Product Group ID],
IBPData[Week Start],
"Actuals", SUM ( IBPData[Sales] ),
"Stat Adjusted", SUM ( IBPData[Stat Adjusted] ),
"Final for Weekly", sum( IBPData[Final for Weekly] ),
"4wk Lag", SUM ( IBPData[4wk Lag Forecast] ),
"13wk Lag", sum( IBPData[13wk Lag Forecast] ),
"Latest Plan M-1", SUM ( IBPData[Latest Plan M-1] ),
"IBP Plan M-3", sum(IBPData[IBP Plan M-3])

),
ABS (
[Actuals]
-
Switch( True(),
SELECTEDVALUE('Forecast Version'[Switch Number] ) = 0,
[Stat Adjusted],
SELECTEDVALUE('Forecast Version'[Switch Number] ) = 1,
[Final for Weekly],
SELECTEDVALUE('Forecast Version'[Switch Number] ) = 2,
[4wk Lag],
SELECTEDVALUE('Forecast Version'[Switch Number] ) = 3,
[13wk Lag],
SELECTEDVALUE('Forecast Version'[Switch Number] ) = 4,
[Latest Plan M-1],
SELECTEDVALUE('Forecast Version'[Switch Number] ) = 5,
[IBP Plan M-3]

)
))
/ SUM ( IBPData[Sales] )

)

 

[Matt Allington]

By definition, SELECTEDVALUE only works when there is a single value. As a result, you can use any other aggregation measure and it will work. MIN, MAX, AVERAGE, SUM, they will all work.

Alternatively, SELECTEDVALUE is shorthand for
If(hasonevalue(table[column]),values(table[column]))
So you can use that.

Also, you can simply your switch statement

Switch( SELECTEDVALUE('Forecast Version'[Switch Number] )
0,[Stat Adjusted],
1,[Final for Weekly],
2,[4wk Lag],
3,[13wk Lag],
4,[Latest Plan M-1],
5,[IBP Plan M-3]

)