cancel
Showing results for
Did you mean:
Highlighted
Member

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

Hi Team,

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

Thanks,

Arvind

4 REPLIES 4
Member

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

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

Member

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

Hi @Ani1991 ,

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

Community Support Team

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

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

Member

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

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

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 44 members 1,175 guests
Recent signins: