Ungroup identical Table Visual Rows without unique column.

[StuartSmith]

Is there a way to stop identical rows grouping?

The row in the image is actually 2 rows, but the visual has grouped them together.  I could split the rows by adding a unique column such as Emp_ID, but need to keep that hidden. 

[Ritaf1983 · Accepted solution]

Hi @StuartSmith 

In order to avoid aggregations inside the table when dragging columns, you must see
You have selected the "don't summarize" option
As shown in the attached image.

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

[StuartSmith]

Thats the first thing I checked, but as the column "(3) Weekdays" is a measure, you dont get the option to "Dont Summerise".  Im currently trying to see if there is a way to prevent a measure summerising.

[Ritaf1983]

@StuartSmith 
A measure is always a result of some type of aggregation.
In the case of a table, choose a column from the table.