Forum Discussion
It does not summarize one table while another does
Hello
I am currently making a dashboard for my company. This dashboard was started before and I am continuing to develop it.
The problem is that the same table, with the same measurement and everything exactly the same, the sum of the data that I have put for a column is made, however, this table was the one made by my predecessor:
However, if I try to do the same for another table, it does not add correctly, but puts one by one several data that I have for that column. The thing is, I need to do this for several different columns since I'm using multiple filters. And if I compare it with any other table I try to make, I don't get that 'Sum of' even though it's the same measure and it's already summarized.
In this case you can see how the 'Sum of' that I need does not appear in the column inserted in the table. Please, any to
Hi,
It's seems to me that the use of implicit measure has been disable on your model because of the use of calculations groups or similar.
Go to the Model view and on the right pane select Model and then select semantic model chekc if you have the option discourage implicit measure turn on:
This feature disable the use of columns and the aggregations using the context button that is why you are seeing all the values instead of the sum. All the visuals created before this feature is turned on keep the aggregation.
Keep this option turned on and create a new measure with the SUM(Table[Column]) and use it on your visual.
8 Replies
Hi,
It's seems to me that the use of implicit measure has been disable on your model because of the use of calculations groups or similar.
Go to the Model view and on the right pane select Model and then select semantic model chekc if you have the option discourage implicit measure turn on:
This feature disable the use of columns and the aggregations using the context button that is why you are seeing all the values instead of the sum. All the visuals created before this feature is turned on keep the aggregation.
Keep this option turned on and create a new measure with the SUM(Table[Column]) and use it on your visual.
Hello
Yes, that was thank you very much!!
Don't forget to accept the correct answer so it can help others.
Hi Syndicate_Admin,
Has your issue been resolved?
If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you.Hi Syndicate_Admin,
Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help.
Thank you.
HI Syndicate_Admin,
.Just a quick check-in! Has your issue been resolved with the information we shared? We’d be delighted to help further if needed.
Thank you.
