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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    vik0810 

     

    Yeah, Thanks !!

    I just accomplished this..

  • 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.

     

     

  • Sweeney1987's avatar
    Sweeney1987
    New Member
    3 years ago

    Worked Beautifully! Thank You.