Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Selected Values function is not avaliable with SSAS as data source

Hi All,   I am not able to find selected value function. I am using SSAS as a data source.   Request your help to solve the problem or you can suggest any alternative for the Selected values func...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    You mean the SELECTEDVALUE function is not avaliable or else? What result do you want, could you please share more details? It's hard to understand your needs based on your description.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

You mean the SELECTEDVALUE function is not avaliable or else? What result do you want, could you please share more details? It's hard to understand your needs based on your description.

Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes..I meant that the SELECTEDVALUE function is not avaliable. I Am using SSAS as a data source.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous, 

    This was a know issue before, but we have fixed it. The function works fine in Power BI desktop, not in Power Bi service? If it is, please create a supported ticket here to get dedicated support.

    Best Regards,
    Angelia

    • rohitbinnani's avatar
      rohitbinnani
      Advocate III
      7 years ago

      Hi v-huizhn-msft, 

       

      Anonymous is trying to refer that she is using SSAS(Analysis Services) as Data Source which is Modelled in Visual Studio and then further connected to Power Bi Directly. We are unable to find the Syntax SELECTEDVALUE in SSAS for DAX that we generally use in Power BI.

       

      Note: Only reply if you have knowledge of SSAS (SQL Server Analysis Services).

       

      Thanks,

      -Rohit

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello Rohit,

        If you used SELECTEDVALUE( Table[column] )  try below alternative :

        if(Hasonevalue(Table[column]),values(Table[column]))

         hope this helps you.

        Reg
        pooja