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
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