cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
arvindyadav Member
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
Ani1991 Member
Member

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

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 Member
Member

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

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

 

Community Support Team
Community Support Team

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

Hi @arvindyadav ,

Assume we have a table like below:

PBIDesktop_9WmT77N571.png

Then we can create a measure like below: 

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

The result will like below:

PBIDesktop_I4GrrTv2e6.png

Best Regards,

Teige

arvindyadav Member
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.

 

Not Matched.PNG

 

 

Thanks,

Arvind

Helpful resources

Announcements
Virtual Launch Event

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

Power BI Helps Homeless and Trouble Youth

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 44 members 1,175 guests
Please welcome our newest community members: