Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello.
I don't know what is happening. I can't summarize any column, sigma symbol is missing and I have summarize option selected. Does anyone have an idea how I can make the symbol appear so I can summarize?
These columns are number types and still sigma symbol is missing.
Solved! Go to Solution.
我没有使用计算组功能,但也发生了此问题.
Hi @inm ,
Are you using the latest version of Power BI Desktop? Does this situation exists only in current .Pbix file or any .Pbix file?
Best Regards,
Jay
@negi007 I can't. But thank you.
@v-jayw-msft Only in the current .pbix file. But I tried to do it in another file, at first the sigma symbol appeared and in some time it stopped appearing. Yes, I'm using the lastest version.
I need to know what I'm doing wrong, because I start to create measures and I get distracted, when I see again all the sigmas symbols disappear and I cannot summarize.
I have the same problem. Field is set to summarize and is a decimal number, but the sigma won't appear and when I drag it to make a visual it creates a table and shows distinct values of the data.
By any chance, are you using Calculation Groups through Tabular Editor ?
@bergerlu Yes, I'm using calculation gruoups through tabular editor. I was wondering if it could be related to that.
I have reproduced the issue, I can confirm that it is caused by the Calculation Group from Tabular Editor
Hi,
What if I have no Calculation groups and still have this problem?
I encountered the same issue. So I can no longer drag a (previous) sigma symbol data value into the value field of a matrix or a watefall after I experimented with Calculation Group.
Is there a way to undo this? I get that this is due to the DiscourageImplicitMeasures being set to false. Is there an option to revert back?
@dharsanj you have to remove every calculation group created before and then change property Discourage Implicit Measures.
You are brilliant and you make my day easy and your answer was direct and straightforward.
thank you
Thanks. That worked.
sh*t, ok finally an explanation, THANKS for the insight: if you use calculation groups no more implicit measures (sigma symbol)
@bergerlu Thank you very much for teaching me that, I was disturbed not knowing why sigma symbol disappeared.
@PaulDBrown I thought that somehow the fact that it was in measure increased the loading time a bit and I wanted to decrease it.
@inm , Even without that symbol you can do that. Just click on the column and in the column tools give default summarization. On the right of the box in screenshot
This helped me figure out what actually was the issue. If you want that summarization option click on the desired column and then change the DATA TYPE and FORMAT to a NUMBER value, chances are, Power BI recognized whatever you put in the column as TEXT instead. 🙂 Hope this helps someone
@amitchandak @Greg_Deckler Thanks for answering. I have Whole number format selected, I'm trying to count number of cases some person has. I don't have the option Default summarization.
I don't want to have every number associated with a person, but the number of numbers.
I know that I can use measures, the problem is that I have many and it takes a while to take, even in a table it runs out of available resources.
@inm - Maybe try distinct count? I'm not sure what I am looking at. Are you summarizing name?
@Greg_Deckler I'm summarization numbers (like distinct count(APP_NUMBER) group by name), I have already tried distinct count.
By default it is selected in column tools to do a distinct count, but it does not. I am trying to use the number of different times per day on area chart, but it won't let move APP_NUMBER to values, it stays in legend. APP_NUMBER is a whole number.
Any choice it's working for me.
@inm Have your tried creating a calculated measure like Count_App = DISTINCTCOUNT(appnumber). Once you create this measure, you can put in the value field. Measure will have calculator icon aginast it.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |