Forum Discussion

DrBiker's avatar
DrBiker
Icon for Advocate II rankAdvocate II
2 years ago
Solved

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

Need Help
  • danextian's avatar
    danextian
    2 years ago

    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.

2 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    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.

  • Monther95's avatar
    Monther95
    New Member
    1 year ago

    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.