No summarize option displayed on menu

[MayBIbewithyou]

Hello,

I'm trying to find what's going wrong with my Power BI desktop because in one of my PBIX file, I can't get no more any "summarize option" available in the right click menu. I'm working with the french version so my capture are in french but menu layout is the same in english.

Here is the regular menu I expect to have when I right click on one value field placed on visualisations panel. We can see Don't summarize ("Ne pas résumer" in french) and following stuff.

But here is the same menu I got in my actual working file. As you see there no option available to Don't summarize/Sum/Average/Count... my values in the visual anymore. 

Someone can find out what I did wrong and explain how to get full option menu back ?

Many Thanks

My PBIX is connected to a PBIS dataflow

[MayBIbewithyou]

Here is a topic about this behaviour. good to know 😉
https://github.com/otykier/TabularEditor/issues/614

I just have to use measure instead

[Nathaniel_C]

Hi @MayBIbewithyou ,

Look on the data screen to see if the values are set correctly.  In this case I have a text, and a numeric column.  The text cannot be summarized. Sometimes the values on this screen can be in error.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[MayBIbewithyou]

Thanks for reply
Yes, all data are well categorized and event default summurization isn't set, option are available in visualisation panel

[amitchandak · Accepted solution]

@MayBIbewithyou , is the second one a measure. Then it will not come.

Also if you have done some changes in Tabular editor, You will not have these options

[MayBIbewithyou]

Thanks for your quick reply. Indeed, I made some calculation group under Tabular editor, but I don't know then, it disable these usefull options. Do you know why it works like this ? Will try to find some info on this now I know where to search