DAX formula help

[Anonymous]

Hi All - I need help with the formulas to produce the results in the last column below. Essentially, I need to calculate the count of weeks for each participant where s/he attended at least 3 days for at least 60 combined mins per day where:

Attended_c = Attended

Fitness_Rollup = Fitness

Attendance Week = >=22

In the sample data for Mitch below, the result should be 1 (week 28).

Name	Date	Attended__c	Time_Spent_	ActivityName	Attendance Week	Fitness_Rollup	Count of Weeks with 3 or more distinct days of 60+mins
Mitch	Wednesday, November 28, 2018	Attended	60	7th Grade Nutrition #3	22		1
Mitch	Monday, December 03, 2018	Attended	60	7th Grade Nutrition #4	23		1
Mitch	Wednesday, January 09, 2019	Attended	60	7th Grade Nutrition #1	28		1
Mitch	Thursday, November 29, 2018	Attended	240	General Attendance	22		1
Mitch	Monday, December 03, 2018	Attended	240	General Attendance	23		1
Mitch	Tuesday, December 04, 2018	Attended	240	General Attendance	23		1
Mitch	Wednesday, December 05, 2018	Attended	240	General Attendance	23		1
Mitch	Thursday, November 01, 2018		240	General Attendance	18		1
Mitch	Friday, November 02, 2018		60	Zumba	18	Fitness	1
Mitch	Monday, November 05, 2018		60	Zumba	19	Fitness	1
Mitch	Friday, November 30, 2018	Attended	180	General Attendance	22		1
Mitch	Tuesday, November 27, 2018	Attended	60	Math Enrichment	22		1
Mitch	Tuesday, December 04, 2018	Attended	60	Math Enrichment	23		1
Mitch	Tuesday, November 20, 2018	Attended	60	Fitness	21	Fitness	1
Mitch	Monday, November 26, 2018	Attended	60	Fitness	22	Fitness	1
Mitch	Tuesday, November 27, 2018	Attended	60	Fitness	22	Fitness	1
Mitch	Monday, December 03, 2018	Attended	60	Fitness	23	Fitness	1
Mitch	Wednesday, December 05, 2018	Attended	60	Fitness	23	Fitness	1
Mitch	Thursday, January 10, 2019	Attended	30	Basketball	28	Fitness	1
Mitch	Tuesday, January 08, 2019	Attended	60	Fitness	28	Fitness	1
Mitch	Wednesday, January 09, 2019	Attended	60	Fitness	28	Fitness	1
Mitch	Thursday, January 10, 2019	Attended	30	Fitness	28	Fitness	1
Mitch	Monday, January 14, 2019	Attended	60	Fitness	29	Fitness	1
Mitch	Monday, November 19, 2018	Attended	60	Basketball	21	Fitness	1

[Anonymous]

Can anyone help with this?

[Ashish_Mathur]

Hi,

Should that be a calculated column formula or a measure?  If it has to be a measure, then share the link from where i can download your PBI file.

[Anonymous]

@Ashish_Mathur I need it to be a calulated column, thanks.

[Ashish_Mathur]

Hi,

I tried but could not get the correct answer using a calculated column formula.