Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

how to avoid aggregation in table

hi expert, I created a table want to see every detail data, but not all dimensions are required, when I did not drag the column2 into table, it summed up automatively even I did set don't summarize

 

what I want is the just show the column1 and value and the value not to sum up, is there any solution to this problem?

notice that the value should be integer rather text

here is the original data look like:

 

Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous 
    There's no option to display the data without summarizing on the row level if it's not unique. That's why you only see one row for 'A' instead of two when using 'column2'.
    So if you need to see all the rows you always neet to combine columns with som unique bslues column or the column that you already have like in your picture here :

    or to create an index column and use it 

    To make an index similar to hidden, just minimize its width:

    pbix with example is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi Anonymous 
    There's no option to display the data without summarizing on the row level if it's not unique. That's why you only see one row for 'A' instead of two when using 'column2'.
    So if you need to see all the rows you always neet to combine columns with som unique bslues column or the column that you already have like in your picture here :

    or to create an index column and use it 

    To make an index similar to hidden, just minimize its width:

    pbix with example is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • nickchobotar's avatar
    nickchobotar
    Skilled Sharer
    2 years ago

    Quick edit.  So, true as Ritaf1983  pointed out due to cardinality it's not possible to use the "Don't summarize" option which is annoying.   

    I can suggest you a trick or rather a hack to circumvent this. The whole idea is to create a duplicate column and concatinate an empty string repeated randomly to the data from the "VALUE" column.  
     
    Here is the DAX but you can accomplish the same in M too. 

    Value2 = 'Table'[Value] & REPT( UNICHAR(32), INT(RAND() * 1000))

     

     

     

    Thanks

    Nick -