Don't summarize option not working

[DrBiker]

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

[Monther95]

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 · Accepted solution]

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.