Measures are not recognizable in Report Mode

[eilina]

Hello, I have an issue with measure columns in some of my reports (created after May-June update): Columns which are supposed to be summarized, e.g. SalesAmount, are not doing it. I have only one fact table in testing case, in Model mode I see "summarization sign" near measure columns, but in Report not and report treats them as dimensions....I have very important project with the same issue. When I create a new report with the same table in another file, it works well, but I need to correct this issue in my older file....such file example with FactInternetSales table is here: https://drive.google.com/file/d/1nSjfFjvOsqItq0vQgTjFLZm4j9oC83oH/view?usp=sharing

Here attaching screenshots:

When I select this measure to display on report, it treats it as a dimention (gives me table):

In Model mode all is right:

Very thankful for your support,

Ekaterina.

[v-lili6-msft]

hi

after test on your pbix file, we find that had created calculated group in this pbix file. So it leads this problem, please have a look this:

https://github.com/otykier/TabularEditor/issues/636

Regards,

Lin

[v-lili6-msft]

hi

If you want to restore the implicit measures functionality, get rid of all calculation groups and set the DiscourageImplicitMeasures Model property to false.
Documentation: https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

Regards,

Lin