I need to find the number of count of 50% CROSSED IN 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.
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.
Hi @arvindyadav ,
Assume we have a table like below:
Then we can create a measure like below:
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[profit %] > 0.5 ) )
The result will like below:
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.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.