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.

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

 

Try MAX()

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski