Forum Discussion

Glums's avatar
Glums
Frequent Visitor
2 years ago
Solved

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 di...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

Glums's avatar
Glums
Frequent Visitor
2 years ago

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 😕