Can't use numeric field as value in a visual (data from Azure Analysis Services)

[Anonymous]

Hello,

I have a model deployed on an Azure Analysis Server and I'm connected to it via LiveQuery using my Power BI desktop.

I have a numeric field that I've defined as Whole Number and It's summarize by Sum in SSDT :

I can use it to create a measure, it's working, I can sum all targets I have. But Power BI doesn't see this field as number, there is not Sigma symbol in front of the field and I can't use it as a value in a visual.

Here, I can't switch the Target into the Value placeholder.

However, Power BI seems to understand that is a numeric field as it's able to sort this field correctly:

I know that if I create a measure and sum this field it will work but I have a lot of them to be use as value in visuals, I don't want to have to create a measure every time I need a numeric field.

Really really would appreciate some help.

Kind regards,

Valentin

[v-easonf-msft]

Hi, @Anonymous 

Are you connnecting to a multidimensional modeling?

It may has something  to this thread.

https://community.powerbi.com/t5/Desktop/Aggregation-Option-Issue-in-Power-BI-Desktop-with-Azure-Analysis/td-p/1124809 

Current model I connected is tabular modeling. In tabular modeling ,I used aggregate functions like SUM, COUNT, MIN, MAX, and DISTINCT COUNT to  aggregated values .I can also use the filed as 'values'  and  select the aggregate type I need to create aggregated values which may not supported in multidimensional modeling.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi, 

Thank you for your reply. 

I'm using a Tabular model and I think Marco Russo has pointed what's causing this issue on his post: https://github.com/otykier/TabularEditor/issues/636

I think at some point I've created a Calculation group which disable by design the implicit aggregations.

I will try to remove any calculation groups.

Thanks again.
 

[Anonymous · Accepted solution]

In the View Code feature, I had to change the value of the property discourageImplicitMeasures from True to False:

Thank you all for your time

[PaulDBrown]

@Anonymous 

Using measures instead of implicit column aggregations is widely considered a best practice. (I never use implicit aggragations)

[v-easonf-msft]

Hi, @Anonymous 

You can check current data format of the field in the model view of the report to ensure that it is  regarded as ‘whole number’ and summarize by  'sum'  .

Have you turned on the option of 'Type detection'?

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hello , thank you for your reply, yeah it's already activated, and Power BI sees it is a whole number:

Any other thoughts?

thanks