Skip to main content
cancel
Showing results for 
Search instead 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

Reply
lennox25
Post Patron
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

1A 
1B 
1C 
1D 
1E 
1F 
1G 
1H 
1I 
1J 
1K 
1L 
1M 
1N 
1O 
1P 
2Q 
2R 
2S 
2T 
2U 
2V 
2W 
2X 
2Y 
2Z 
3AA 
3BB 
3CC09/05/2023
3DD01/06/2023
3EE09/05/2023
3FF01/06/2023
3GG09/05/2023
4HH10/05/2023
4II10/05/2023
4JJ 
4KK 
5LL 
5MM 
5NN 
5OO 
5PP 
5QQ 
5RR 
5SS 
6TT 
6UU22/05/2023
6VV22/05/2023
6WW22/05/2023
6XX 
7YY 
7ZZ 
7AAA 
7BBB 
7CCC 
7DDD 
7EEE 
7FFF 
7GGG 
7HHH 
7III 
8JJJ08/06/2023
8KKK 
8LLL 
8MMM08/06/2023
8NNN 
8OOO 
8PPP15/05/2023
8QQQ 
8RRR03/05/2023
8SSS 
9TTT 
9UUU 
9VVV 
9XXX 
9YYY 
9ZZZ 
2 ACCEPTED SOLUTIONS
mlsx4
Super User
Super User

Hi @lennox25 

 

Use this formula

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

View solution in original post

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

View solution in original post

3 REPLIES 3
mlsx4
Super User
Super User

Hi @lennox25 

 

Use this formula

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

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors