how to avoid aggregation in table

[oakfc]

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:

[Ritaf1983 · Accepted solution]

Hi @oakfc 
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]

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 -