Forum Discussion
How to display Decimal values without aggregation
Hi harib,
When you use live mode, these calculated fields still host and processed on your database side, power bi only connects and shows the result on the power bi side.
So these calculate field has been recognized correctly as calculated with raw expressions. If your expressions existed specific filters or conditions, it may not works properly on the total level, you need to add if statement with filters to trace and process the total level calculations.Measure Totals, The Final Word
If you use the import mode, power bi will break expression and convert them to static values which support aggregate.
For this scenario, it is hard to prevent the aggregate of these fields even if you setting the data category to 'do not summarize', they will also aggregate with 'count'/'first'/'last' mode when you use on matrix value fields which only allow showing the summarized values.
Regards,
Xiaoxin Sheng
This is a bit of a guess but powerbi uses some intelligence behind the scenes to only offer options in the Values well that make sense.
I wonder if the model and relationships that you have are preventing 'do not summarize' from being offered because it doesn't make a difference i.e. the values would be the same in a visualisation - and this implies that the relationships in the directquery model do allow a 'do not summarize' because they would show a difference .
Perhaps you could investigate this.