Calculate number of dates in column

[Anonymous]

Hello,

New with power bi and didn't find anything that worked for me in the community.

If I have the follwing data:

Date_Out	Car type
7.6.2020	1
8.6.2020	1
9.6.2020	1
10.6.2020	1
10.6.2020	2
10.6.2020	2
11.6.2020	1
11.6.2020	3
11.6.2020	1
11.6.2020	2

I would like to be able to count the how many instances there are of each date, and if possible, also count for dates that are not included, see this table:

Date_Out	Count
7.6.2020	1
8.6.2020	1
9.6.2020	1
10.6.2020	3
11.6.2020	4
12.6.2020	0

Also, if I would filter by car type, only, so if I would filter out for Car Type 1 only, then the results would be:

Date_Out	Count for Car Type 1
7.6.2020	1
8.6.2020	1
9.6.2020	1
10.6.2020	1
11.6.2020	2
12.6.2020	0

Is there a clever way to accomplish this?

any help is appreciated 🙂

[amitchandak]

@Anonymous , Please find the attached pbix after the signature. See if it can help.

Count of type column used. Count Measure created.

Type used as slicer