Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Alternative of SELECTEDVALUE DAX function

Guys,   We have a Employee Name Slicer in Power BI and were showing some counts based on slicer selection using SELECTEDVALUE function. We are migrating our entire steup to Prod environment on SSAS...
Need Help
  • vik0810's avatar
    vik0810
    6 years ago

    HI,

     

    SELECTEDVALUE is internally translated into following

     

    IF ( HASONEVALUE ( Table[column] ), VALUES ( Table[column] ) )

     So just use the IF expansion. And it does work with string types also.

vik0810's avatar
vik0810
Icon for Resolver V rankResolver V
6 years ago

HI,

 

SELECTEDVALUE is internally translated into following

 

IF ( HASONEVALUE ( Table[column] ), VALUES ( Table[column] ) )

 So just use the IF expansion. And it does work with string types also.

cabc_xlorla's avatar
cabc_xlorla
Icon for Advocate IV rankAdvocate IV
5 years ago

Your formula:

IF ( HASONEVALUE ( Table[column] ), VALUES ( Table[column] ) )

is a personal-game-changer for me.  Thanks!
Please feel free to connect with me.