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.
2 Comments
v-lili6-msftCommunity Support
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
DiscourageImplicitMeasuresModel property tofalse.
Documentation: https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversionsRegards,
Lin