Count the first occurrences using set analysis

[Micki]

Hi folks, have a table

My measure:

count(
	aggr(
	if(	{<
		[State] ={'Closed', 'Resolved'},		
		>} FirstSortedValue([Id], -[Week]), 1,0), [Id]))

And it's not working what i want to count 1 in 21-Sep-2020 and that it, Could you please help ?

thank you in advance

[Vegar]

Your SET modifier is misplaced outside of the aggregation function.

Try it like this.

count(
	aggr(
	if(	FirstSortedValue({<
		[State] ={'Closed', 'Resolved'},		
		>} [Id], -[Week]), 1,0), [Id]))

[Micki]

not working:( 

[sunny_talwar · Accepted solution]

@Micki May be try this

Sum(Aggr(

    If(Week = Min({<State = {'Closed', 'Resolved'}>}TOTAL <Id> Week), 1, 0)

, Id, Week))

[Micki]

@sunny_talwar Thank you so much!!!