Attributes with the Same Value are Removed Even When Do Not Summarize Is Selected

[JasonMJones]

I have a table which has decimal numbers as portions of hours.  The grain of the hours is per entry; N number of time entries can be entered for a calendar date.  When I create a table with the value set to Do Not Summarize, time entries with the same value are missing (distinct).  When I add the value with the Sum aggregation the hours sum properly.  

[amitchandak]

@JasonMJones 

You can use do not summarize in a table, not in the matrix. That might not help in this case.

Create an index column and add that (Not Summarized )

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448

[JasonMJones]

Thank you for your quick response and the suggestion, but I am using a table in the example. 

[mwegener · Accepted solution]

Hi @JasonMJones ,

Power BI shows the data in two ways ...
1. as aggregable value. (e.g. SUM)
2. as category (distinct)
... that's how it is at design.

If you want to see each entry \ value, something must be displayed that differentiates the values.