Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Issue with Summarization on Power BI -- basic table

Submitted by Anonymous on ‎10-20-2020 07:06 AM

Hello, 

Suddenly I am having this issue where my "whole number" data (formatted as whole number) cannot be summarized at all without creating a SUM measure. Before, I could use a table, and drop a whole number data format column and it would SUM it or I could change it to AVERAGE or COUNT, etc. But right now, no matter what I do, it does not show any option for summarization - no SUM, AVERAGE, COUNT, COUNT(DISTINCT). Please help. 


FYI - columns are formatted as whole numbers. Here are some screenshots:

1st screenshot: showing that this column with the name "EMAIL COUNT" is type and format as Whole number.

Soo_Reed_1-1603202669059.png

2nd screenshot: table not summing the data and not showing any option for summarization for the same column. 
Soo_Reed_0-1603202633852.png

 



Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎10-21-2020 01:15 AM

@Anonymous 

 

You may check the link below.

https://github.com/otykier/TabularEditor/issues/636

Anonymous
Not applicable
‎10-21-2020 06:04 AM

@v-chuncz-msft Thank you for the reply. The link you provided does seem to point the right direction to the solution I need, but it does not directly apply to me as I do not have a calculation group in this particular report. Please let me know if implicit measures are disabled in any other cases. 

Idea Statuses