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
rlhim
Helper I
Helper I

Need to create a measure that counts the amount of weeks there has been training

I has been trying to create a measure that calculates the sum of weeks they trained. They can train more than once a week but we only check if its been done or not.

I don't know if its better to have a boolean answer or a numeric answer.

I've been trying to do it with if, something along the lines of if(Week>=1, 1,0) but can't seem to make it work

My data looks more or less like this

IDNameWeekDate
1Edwin11/1/2023
3Alexander11/2/2023
2Rachel21/8/2023
2Rachel21/9/2023
3Alexander21/11/2023
1Edwin31/15/2023
2Rachel31/17/2023
2Rachel31/18/2023
3Alexander31/19/2023

The answer I want is 

Rachel 2

Edwin 2

Alexander 3

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@rlhim try this measure:

 

Count Week = COUNTROWS  ( SUMMARIZE ( 'MyTable', MyTable[Name], MyTable[Week] ) )


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

1 REPLY 1
parry2k
Super User
Super User

@rlhim try this measure:

 

Count Week = COUNTROWS  ( SUMMARIZE ( 'MyTable', MyTable[Name], MyTable[Week] ) )


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.