Multiple Items but want to count only once rest 0

[Anonymous]

Need help in solving this problem. I have multiple category with differenc operation but i want show only once evern there are multiple operations.
Category	Opno	
100	10	
100	20	
100	30	
100	40	
100	50	
200	10	
200	20	
200	30	
300	10	
300	20	
300	30	
500	10	
600	10	
		
		
Output		
Category	Opno	Count(Category)
100	10	1
100	20	0
100	30	0
100	40	0
100	50	0
200	10	1
200	20	0
200	30	0
300	10	1
300	20	0
300	30	0
500	10	1
600	10	1

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Try to create a measure like this:

Measure = IF(MAX('table'[opno])=CALCULATE(FIRSTNONBLANK('table'[opno],1),ALLEXCEPT('table','table'[categories])),1,0)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Perhaps:

Count Column =
  VAR __Min = MINX(FILTER('Table',[Category] = EARLIER([Category])),[Opno])
RETURN
  IF([Opno] = __Min,1,0)