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

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

 ID Name Week Date 1 Edwin 1 1/1/2023 3 Alexander 1 1/2/2023 2 Rachel 2 1/8/2023 2 Rachel 2 1/9/2023 3 Alexander 2 1/11/2023 1 Edwin 3 1/15/2023 2 Rachel 3 1/17/2023 2 Rachel 3 1/18/2023 3 Alexander 3 1/19/2023

The answer I want is

Rachel 2

Edwin 2

Alexander 3

1 ACCEPTED SOLUTION
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.

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.