Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
DrBiker
Advocate II
Advocate II

Don't summarize option not working

Hi,

 

On a table visual I have data with four values such as A, A, B, B.  When I ask it not to summerise I find that it does summarise with results of only two rows.

 

Anyone have any ideas?  This seems to have started after the last update to PBI.

 

Thanks in advance

 

Paul

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @DrBiker 

 

A dimension will always be summarized based on its distinct values such as A will is displayed once no matter how A's a column has. You need to add  a column to a table that returns a different value for each instance of A like an index column.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

2 REPLIES 2
Monther95
New Member

Go to Options and Settings, then Options:

Under Global, move down to Diagnostics, then under Query Diagnostics/Diagnostics Level, untick Aggregated.
 Hope this will help you.

 

danextian
Super User
Super User

Hi @DrBiker 

 

A dimension will always be summarized based on its distinct values such as A will is displayed once no matter how A's a column has. You need to add  a column to a table that returns a different value for each instance of A like an index column.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors