create a measure that count sum of same time

[qwertzuiop]

Dear PowerBI Community

First of all: Good luck for 2020!

I have the following question:

I want to create a measure that returns me the number of times the time 01:00 occurs in the column

For example, the measure for this table should return the number "4".

Think its not easy because its not an interger to check.

So the following expression does not work: 

measure = COUNTX(FILTER('table';[timeOfCreation]=01:00))

timeOfCreation

01:00

02:00

03:00

01:00

02:00

01:00

03:00

01:00

Thank you so much for your help.

Cheers!

qwertzuiop

[Anonymous · Accepted solution]

Hi @qwertzuiop 

Create measure,

Measure = CALCULATE(COUNT('Time'[Column]),FILTER('Time','Time'[Column]="01:00"))

Thanks & regards,

Pravin Wattamwar

www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Alternative,

Measure 2 = COUNTAX(FILTER('Time','Time'[Column]="01:00"),'Time'[Column])

Thanks & regards,

Pravin Wattamwar

www.linkedin.com/in/pravin-p-wattamwar