cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron

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

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
2 ACCEPTED SOLUTIONS
Super User

Use this formula

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

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

3 REPLIES 3
Super User

Use this formula

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

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

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.