Forum Discussion
Aggregation not available - weird behavior
Hi Glums ,
When you enable calculation groups, Tabular Editor enables the Model option and discourages Implicit Measure. If you remove all the calculation groups, you can restore that property to False to enable implicit measures again.
To resolve this issue, you can connect to Tabular Editor and set Implicit measures to TRUE. This should make the aggregation available on Power BI Desktop again.
Another possible solution is to try disabling the “Store datasets using enhanced metadata format” option in Power BI Desktop. This feature can cause issues with Tabular Editor, and disabling it may resolve the error message you’re seeing.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Glums ,
I am unable to reproduce your problem, please uninstall and reinstall the latest version of Power BI Desktop.
If the default aggregation does not work, please consider creating a DAX measure to calculate the earliest date. Then use this measure in the card visual object.
Measure = MIN('Table'[project end])
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I investigated for quite a while and the problem seems to be coming from "Discourage Implicit Measures". I clicked on "Calculated Group" to see what it did and it is likely where my problem is coming from.
I would need to use Tabular Editor to revert but when I try to import my pbix file to the tool I have an error message "Unable to load tabular model [...] Error: unexpected character encountered while parsing value: P.Path '', line 0, position 0."
Hi Glums ,
When you enable calculation groups, Tabular Editor enables the Model option and discourages Implicit Measure. If you remove all the calculation groups, you can restore that property to False to enable implicit measures again.
To resolve this issue, you can connect to Tabular Editor and set Implicit measures to TRUE. This should make the aggregation available on Power BI Desktop again.
Another possible solution is to try disabling the “Store datasets using enhanced metadata format” option in Power BI Desktop. This feature can cause issues with Tabular Editor, and disabling it may resolve the error message you’re seeing.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I have never installed tabular editor but in the latest version of powerbi can still use calculation groups by enabling it from options and settings. I am facing the same problem but only difference is I cannot find how to enable implicit measures without a tabular editor. Do you know how to?
