Bug aggregating data on Dual/Import mode

Hi Frbelotto ,

Based on your description, it seems that changing the storage schema affects the behaviour of aggregations in the Matrix visualisation. As you have observed, switching modes results in different outputs due to the different ways in which data is stored and queried. For a detailed explanation of these storage modes, see the Power BI documentation on storage modes:

Use storage mode in Power BI Desktop - Power BI | Microsoft Learn

The following are a few steps and considerations for troubleshooting and possibly resolving the issue:

1. Ensure that the aggregation tables are configured correctly. This includes checking the Manage Aggregations dialogue box in Power BI Desktop to confirm that the aggregation behavior for each column is correctly defined. For more information on configuring data sources for aggregations, visit the following link:
   User-defined aggregations - Power BI | Microsoft Learn
2. When changing to dual or import mode, it is critical to verify that the storage mode settings match your data and reporting needs. Import mode caches data in memory, which affects how the data is refreshed and displayed. Dual mode offers more flexibility, but needs to be configured carefully to ensure it behaves as expected in different query contexts.

If the problem persists after reviewing these steps, could you please provide more specific details about the configuration? For example what specific aggregations are you applying to the table? Are there any calculated columns or metrics that might be affected by the storage schema change?

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.