cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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

 

Thanks in advance.

 

Regards,

Pooja Dhonde

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

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

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

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

View solution in original post

Highlighted
Anonymous
Not applicable

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

Highlighted

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

Highlighted

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

Highlighted
Anonymous
Not applicable

Hello Rohit,

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

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

 hope this helps you.

Reg
pooja

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors