How to count rows where a value is reached in a week.

[jackjamesbaker]

Not sure if my question makes sense but here we go...

I have a system where hours are logged against people each day. I want a way to show all records where a persons hours are greater than 20 in any week. The only measure I can get working doesn't seperate weeks, and just shows anyone with hours over 20, which is everyone. 

[v-robertq-msft · Accepted solution]

Hi, @jackjamesbaker 

According to your description, I can roughly understand your requirement, I think that if you want to make the measure separate weeks, you can just place the [Week] column into the table chart or into a slicer and change the measure like this:

Count = CALCULATE(COUNT('Table'[Person]),FILTER(ALL('Table'),[Hours]>=20&&[Week]=SELECTEDVALUE('Table'[Week])))

Then you can create a card chart and a slicer to place them like this:

And you can get what you want.

You can download my test pbix file below

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi, @jackjamesbaker 

I am not sure if I understood your question correctly, but I think you need to filter the context of which week you want to show.

Do you want to show this week's result or last week's result? Or, do you want to show every week's result? I think you can achieve this by having a proper dim-date table with a week-column.

Please share your sample pbix file's link here, then I can try to look into it to come up with a more relevant solution.

Thanks.