Forum Discussion
Unable to Perform Direct Aggregations on Numeric Columns in Power BI Visuals
I’m facing an issue in Power BI where I am no longer able to perform calculations directly on numeric columns in visuals. Previously, I could apply aggregations (like sum, average, etc.) directly on numeric columns when adding them to visuals. However, now I am required to manually create measures for any aggregation.
This issue occurs in both Import and DirectQuery modes, significantly increasing the load time of visuals and negatively impacting the overall performance of the report.
Could someone please help me understand why this is happening and suggest a resolution?
Hi mohita98, This is the case of Implicit/Explicit Measure.
To enable the direct aggregation you can go to Modelling tab and click on the semantic model. In the properties pane you will find the option to discourage implicit measure button, turn it off and you will be able to perform direct aggregation.
Please find attached the screenshot for your reference:
2 Replies
Hi mohita98, This is the case of Implicit/Explicit Measure.
To enable the direct aggregation you can go to Modelling tab and click on the semantic model. In the properties pane you will find the option to discourage implicit measure button, turn it off and you will be able to perform direct aggregation.
Please find attached the screenshot for your reference:There are a few potential reasons why you might be experiencing this change in behavior:
Power BI Updates: Sometimes, updates to Power BI can change how certain features work. It’s possible that a recent update has altered the default behavior for aggregations on numeric columns.
Data Model Changes: If there have been changes to your data model, such as renaming columns or modifying relationships, it might affect how aggregations are handled1.
Aggregation Settings: Power BI has specific settings for managing aggregations. If these settings have been altered, it could require you to create measures manually2.
Possible Solutions
Check for Updates: Ensure that you are using the latest version of Power BI. Sometimes, issues are resolved in newer updates.
Review Data Model: Verify that there haven’t been any unintended changes to your data model. Ensure that all relationships and column names are correctly configured.
Manage Aggregations: Use the “Manage Aggregations” feature in Power BI to define how aggregations should be handled. This can help streamline the process and potentially resolve your issue2.
Automatic Aggregations: If you are using a Premium subscription, consider enabling automatic aggregations. This feature can optimize performance and reduce the need for manual measures3.
If these steps don’t resolve the issue, you might want to reach out to the Power BI community or support for more specific guidance. Let me know if you need further assistance!
You can follow the following given below link for moure understanding:
(3) Solved: Manage Aggregations: Detail Column Cannot be Aggr... - Microsoft Fabric Community
User-defined aggregations - Power BI | Microsoft Learn
Automatic aggregations overview - Power BI | Microsoft Learn
