Count number of weeks with a certain value over

[lukass]

Hello Community,

I'm trying to create a card visual showing a "Number of Weeks with Over 200 count"

I have two tables, date table and my other table where my ID count comes from, joining on a date field. So far, I've created a measure, "# Over 200" that indicates which week has a value over 200.

Now, I need to count those weeks and display a number of weeks in a card visual. Any suggestions? 

[Anonymous · Accepted solution]

Hi @lukass ,

I suggest you to create a new measure based on [# Over 200].

Number of Weeks with Over 200 count =
SUMX ( VALUES ( 'TableName'[WorkWeek] ), [# Over 200] )

Best Regards,
Rico Zhou

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

[mlsx4]

Hi @lukass 

Try this:

OVER 200 COUNT = SUMX('Table', IF([Over 200]=1,1,0))