Forum Discussion
Tabular model calculation (measures) totals
Is there any possibility how to switch off calculations (measures) total in SSAS Tabular Model? I use direct query mode in Power BI desktop and I am not able to hide calculation totals in table. (I do not want to switch off the Totals in Format - General)
It is easy to hide totals on individual column (Properties -> Summarize by -> Do not summarize). But there is no such option on calculation (measures).
Tanks.
8 Replies
ankitpatira As I said, I do not want to use this function. It is because the fact, that I want to have table where some columns have totals, but some do not have. So I would prefer some function in tabular mode, where I can hide (disable) totals on measure. For example like when I can set Summarize by to Do not summarize on Column properties.
Because the fact, that I use Direct Query mode neither I can use Default summarization option in Power BI Desktop. It is not active.
Hi PavelR,
If you use the live connection mode to connect to SSAS database, the modeling features will be disabled.“Question: If I created a live connection, can I edit the model or query in Power BI Desktop?
Answer: No. All of the query and modeling features in Power BI Desktop are disabled when exploring live data.”
Based on test, I find if you set the summarize properties to “Do not summarize” for a numeric field on SSAS side, when connect to SSAS in live connection, we can also set the aggregate functions for this field, though there is no ∑ signal.
If you want to modify the setting of these fields, you can right-click on these fields and modify summarize option:
Regards,
Xiaoxin Sheng
