Cannot aggregate a column

[hansei]

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?

[hansei · Accepted solution]

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=asallprodu...

[ribisht17]

@hansei 

Is it of type Text in the second one?

Regards,

Ritesh

[hansei]

@ribisht17 
No, the column is numeric in both. That is why you see numeric aggregations like Sum instead of First/Last.