Forum Discussion
Group BY
Power Query transforms and Power BI DAX calculated columns are immutable - they are only calculated once during the initial load and will not react to end users interacting with the filters on your report. Most likely you are looking to create a measure that does the grouping for you (there are lots of DAX functions for that).
Hi MissEllaZ ,
Yes, this is expected behavior in Power BI. When you use the Group By feature in Power Query, the aggregations are performed during data load, and the results are stored as regular columns in the model rather than dynamic measures. Because of this, Power BI treats them as standard fields, not as measures, which is why you’re unable to change their aggregation or use them flexibly in visuals without creating new DAX measures. Changing the data type doesn’t affect this behavior since the limitation is due to how the data is modeled, not its type. If you need dynamic calculations such as averages, sums, or filter responsive metrics, you’ll need to create measures in DAX and ideally keep your data at a more granular level instead of fully aggregating it in Power Query.
Keep data at granular level and create measures in DAX like:
Total Sales = SUM(Table[Sales])
Avg Sales = AVERAGE(Table[Sales])
Hope this helps.
Thank you
Hi MissEllaZ ,
Yes, this is expected behavior in Power BI. When you use the Group By feature in Power Query, the aggregations are performed during data load, and the results are stored as regular columns in the model rather than dynamic measures. Because of this, Power BI treats them as standard fields, not as measures, which is why you’re unable to change their aggregation or use them flexibly in visuals without creating new DAX measures. Changing the data type doesn’t affect this behavior since the limitation is due to how the data is modeled, not its type. If you need dynamic calculations such as averages, sums, or filter responsive metrics, you’ll need to create measures in DAX and ideally keep your data at a more granular level instead of fully aggregating it in Power Query.
Keep data at granular level and create measures in DAX like:
Total Sales = SUM(Table[Sales])
Avg Sales = AVERAGE(Table[Sales])
Hope this helps.
Thank you