Forum Discussion
Cannot aggregate a column
I have a table visual with values added from table columns (not measures). Many of the columns have aggregates applied (sum, latest, etc.). However, I cannot change aggregation or aggregate any new columns added. e.g. You can see in this tooltip that Payments Insurance is aggregated as a Sum.
However, if I right-click the value name (Ins Paid) or click the chevron, I can neither change or remove the aggregation. This is the case for every value in the visual.
When I look at a much older version of the report, I can do so as expected.
I am unable to revert the report to the much older version, due to the wealth of changes. Both reports are using the same version of PBI desktop (same machine). What could cause this?
For any who stumble on this, itt would appear that this is because of a calculation group in the newer report, where implicit measures can no longer be created https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#benefits
3 Replies
For any who stumble on this, itt would appear that this is because of a calculation group in the newer report, where implicit measures can no longer be created https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#benefits
