Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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...
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
No, the column is numeric in both. That is why you see numeric aggregations like Sum instead of First/Last.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |