HELP! Column/Measure to show how many completed per store no

[lennox25]

Hi, 

Please see sample data. I need a column/measure to show how many people have completed training per store no.

Store NoFull NameDate Training Completed

1	A
1	B
1	C
1	D
1	E
1	F
1	G
1	H
1	I
1	J
1	K
1	L
1	M
1	N
1	O
1	P
2	Q
2	R
2	S
2	T
2	U
2	V
2	W
2	X
2	Y
2	Z
3	AA
3	BB
3	CC	09/05/2023
3	DD	01/06/2023
3	EE	09/05/2023
3	FF	01/06/2023
3	GG	09/05/2023
4	HH	10/05/2023
4	II	10/05/2023
4	JJ
4	KK
5	LL
5	MM
5	NN
5	OO
5	PP
5	QQ
5	RR
5	SS
6	TT
6	UU	22/05/2023
6	VV	22/05/2023
6	WW	22/05/2023
6	XX
7	YY
7	ZZ
7	AAA
7	BBB
7	CCC
7	DDD
7	EEE
7	FFF
7	GGG
7	HHH
7	III
8	JJJ	08/06/2023
8	KKK
8	LLL
8	MMM	08/06/2023
8	NNN
8	OOO
8	PPP	15/05/2023
8	QQQ
8	RRR	03/05/2023
8	SSS
9	TTT
9	UUU
9	VVV
9	XXX
9	YYY
9	ZZZ

[mlsx4 · Accepted solution]

Hi @lennox25 

Use this formula

Number completed = CALCULATE(DISTINCTCOUNT(Table[NoFull Name]),Table[Date Training Completed]<>BLANK())

[mlsx4 · Accepted solution]

Hi @lennox25 

Use this formula

Number completed = CALCULATE(DISTINCTCOUNT(Table[NoFull Name]),Table[Date Training Completed]<>BLANK())

[lennox25]

Thank you @mlsx4  but how can I show this per store no? I.e How many complete for each?

[mlsx4 · Accepted solution]

If you put it on a table you will get it. If you want to show it individually, you can create another measure using filter or use the filter pane to select the one you want