MIN, MAX etc will not show up in one PBI file

[Anonymous]

I'm missing
- Don't summarize
- Sum
- Average
- Minimum
- Maximum
- Count(Distinct)
- Count
- Standard
- Variance
- Median

On all tables in one report. When I add one column to a visual and want to get the minimum value it is not possible.

If I try to create a new pbi file with one of the tables, the menu will pop up as normal.
What is wrong in the file that is not working?
Is it a setting in the pbi file that can turn off this from all tables?
Please help, I can't rebuild this model it is really big.

Regards
Tobias

[v-xulin-mstf]

Hi @Anonymous,

Maybe the data model you import into power bi contains calculation group.

Implicit column aggregations in Power BI are not supported for models with calculation groups. 

Currently, if DiscourageImplicitMeasures property is set to false (default), aggregation options appear, however they cannot be applied. If DiscourageImplicitMeasures is set to true, aggregation options do not appear.

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

For your information I have noticed that in the report that is working, I can see that I see the sum sign both in model view and the data view.
But in the report that is not working I can only see in the in the model view.
But if I compare one the column in both files I have the same setting in tab "Column tools"
with Summarization = Sum.
And if I use the column in a visual it summarize in the file that is working and in the other not. Really strange.

[Anonymous]

I also tried to clear the cache but no changes.

[Anonymous]

I removed everything from the file that is not working and added the data from the view again but still same behavour the functions will not show up.
And if I create a new file and do the same, it is working.

Maybe this can be interesting, I have got a new computer and the file that is not working is created on my old computer.

I really hope that it should not be any issues with that.
But it looks like it is related to the file itself

[MFelix]

HI @Anonymous ,

Check the type of data for your columns, for each type of data the summarization is different.

How are you getting the information for that PBI file? are you replicating the model? be aware that if you want to use the same model on different PBI the best option is to have all the model setup in a file and then use PowerBI datasets to get the values, that way all formatting, changes and measure will be updated on all you PBIX files.

[Anonymous]

Yes, I have one file for only the model and the reports are build on that dataset.
This is the model file.
I'm reading many views from a SQL server database with Import.
But I have the same behavour of all of them in this file.
But If I create a new file just for testing, it is working as normal.

[amitchandak]

@Anonymous , This is strange. Have created some calculation groups in that file?

[Anonymous]

Yes I have calculation groups in the file.

[MFelix]

Be aware that calculation groups, do no allow implicit measures so the summarization will not be available to add them, to your visuals. You need to do Explicit measure in this case the MIN(Table[Column])

Check the limitations on the link below:

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

[Anonymous]

I have removed all tables ... from the model and added the data from the view again but still same behavour the functions will not show up.
And if I create a new file and do the same, it is working.

Can it be a setting from the calculation group that's still are in the file, that cause the problem or can it be something else?