How to find number of time crossed 50% in a month

[arvindyadav]

Hi Team,

I need to find the number of count of 50% CROSSED IN MONTH.

Thanks,

Arvind

[Ani1991]

Hi @arvindyadav 

If you don't mind can you please ellaborate more on your question as in count of what crossed 50% in a month and so. That will help us help you better.

Thanks,

Anish 

[arvindyadav]

Hi @Ani1991 ,

Thanks for the reply.

Suppose we have employees named as Ashish, Arvind, Soumyadeep etc,..

and I want to know how many times in the month of august Ashish crossed 50% profit % . Basically, I need to count of that.

If Ashish crossed 50% in the date of  8/10/2019, 8/11/2019, 8/18/2019, 8/30/2019 then the total count of Ashish that he crossed50% profit % in the month of August is 4.

Same for other employees too.

Thanks,

Arvind

[TeigeGao]

Hi @arvindyadav ,

Assume we have a table like below:

Then we can create a measure like below: 

Measure =
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[profit %] > 0.5 ) )

The result will like below:

Best Regards,

Teige

[arvindyadav]

Hi @TeigeGao ,

Thanks for the solution but It is not giving me the correct answer.

We have an employee named as Agam he hit 10times 50% above but after applying your formula I am getting 42 counts.

Thanks,

Arvind