Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Glums
Frequent Visitor

Aggregation not available - weird behavior

Hi everyone,

 

I am having an extremely weird behavior with cards visuals, and I cannot figure out where the problem is coming from

These both views are coming from the exact same source, and I did not change any data type as well.

On the right end side it is a new PBI document and it works as intended - I can get the earliest date of that field

On the left end side I need to see that earliest date but for some unknown reasons it does not let me do so. Note that this table is not linked to any other table, as well as this report page is completely empty, and I do not have filters applied on that report page...PBI tells me "Aggregation can't be applied to data in this field well".

Would you have any idea where this is coming and how I can solve this problem?

 

Many thanks

 

Glums_1-1704537167900.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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. 

View solution in original post

6 REPLIES 6
SB3
New Member

Iam also having the same issue I just entered the numbers using the enter data options but the aggregation is not available.

Can any one help me on this.


Thanks 

Anonymous
Not applicable

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])

 

vtangjiemsft_0-1704679456301.png

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."

Anonymous
Not applicable

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?

Glums
Frequent Visitor

Some additional information as I try to fix my problem

On the file where it works as intended (top screenshot) I noticed that I have much more options to select comparatively to the file I'd like to use (bottom screenshot)

Again these fields are exactly the same, it is really bugging me 😕

 

Glums_0-1704540878585.png

Glums_1-1704540916925.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.