Gather same Date instead to have each row

Hi ItSupportElm 

Click on Id column in the Visializations pane and set "Count" summarizaion as active

Hi ItSupportElm ,

Check for 2 things:

1. Check that the format of your date column is DATE type not DATETIME type

2. When you move ID column to the visual along with Date column, set Summarisation on ID column to COUNT

Thanks,

Pragati

Hi, ItSupportElm 

Based on your description, I created data to reproduce your scenario.

You may create a table visual to display the reuslt and drag two columns from 'Table'. Please make sure the aggregation for id is 'Count'.

As a workaround, you may create a measure as follows.

CountForDate = 
CALCULATE(
    COUNTROWS(
        FILTER(
            ALLSELECTED('Table'),
            'Table'[DateCreation]=MAX('Table'[DateCreation])
        )
    )
)

Result:

Best Regards

Allan

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