Issues displaying numeric values from SSAS Cube DirectQuery (cannot select mean, max, min, ecc.)

[MaxItaly]

Hello everyone!
I am currently having an issue with Analysis Service.
It's my first time working with Analysis Service, so maybe it's just me not understanding correctly what I am able to do with it.

I have created and deployed a cube using Visual Studio and I used Power BI in direct query mode to connect to it.
I can see the measures and dimensions I created, but I am being very limitated to what I can do in the reports.

As shown in the screenshot below, for example, I cannot create a visual object and use a function of a column with numeric values (mean, max, min, ecc.).

My question is: is it possible to use those functions using SSAS in Direct Query and/or import mode, just like in the screenshot below?

I am not very used to cubes too, so maybe I did something wrong earlier. I'd like to know if someone managed to achieve what I mean to do.

Many thanks to anyone who can give me an opinon about it!

[v-qiuyu-msft · Accepted solution]

Hi @MaxItaly,

In your first screenshot, the value you drag into the card visual is a measure, it doesn't need any aggregate function. Based on my test, the field instead of measure can't be set with aggregate function in SSAS cube live connection. You can vote on these two ideas:

Aggregation Options (Mean, Median, SD, VAR) for Live Connections (SSAS)

Calculated measures when live connected to MDX cubes

You can connect to SSAS cube in Import mode to select desired measure and dimension to get new table in the desktop, then you can use the aggregate function when you drag any column into the card visual.

Best Regards,
QiuyunYu

[MaxItaly]

I really hoped I was doing something wrong, this is very, very, impractical.

Thanks for you contribution. I really hope I won't have to use live connection and ssas.

And many thanks for showing me those two ideas, they immediatly had my vote!