DAX Formula for location with Date Visited

[Cio]

Hello all and thank you in advance. 

I have a report that deals with stores and visits. I would like to be able to create a chart that shows stores with "Missed Visit" for the week.

Example:

Store #	City	State	9/8/2024	9/9/2024	9/10/2024	9/11/2024	9/12/2024	9/13/2024	9/14/2024	Visited/Missed
3023	SAN JOSE	CA	1	0	1	1	1	1	1	Visited
3090	ROCKLIN	CA	0	0	0	0	0	0	0	Missed
3126	AURORA	CO	0	0	0	0	1	0	0	Visited
3144	PORTLAND	OR	0	0	0	0	0	0	1	Visited
4147	MORRISVILLE	NC	0	0	0	0	0	0	0	Missed
4182	PLANO	TX	0	1	0	0	0	0	0	Visited
4415	El Paso	TX	0	0	0	0	0	0	0	Missed
4603	TUCSON	AZ	0	0	0	1	1	0	0	Visited
5007	VACAVILLE	CA	0	0	0	0	0	0	0	Missed
5603	DOWNEY	CA	0	0	0	0	0	0	0	Missed
5606	WOODLAND	CA	0	0	1	1	1	0	0	Visited
5609	VALLEJO	CA	0	1	1	0	0	0	0	Visited
5627	GRESHAM	OR	0	0	0	0	0	0	0	Missed
5653	ORANGE BEACH	AL	0	0	0	1	1	1	1	Visited
5855	WICHITA	KS	0	1	0	1	0	1	0	Visited
5990	WICHITA	KS	0	0	0	0	0	0	0	Missed
1063	GENEVA	AL	0	0	0	0	0	0	0	Missed
1067	HALLETTSVILLE	TX	0	0	0	0	0	0	0	Missed
1095	GLENWOOD SPRINGS	CO	0	0	0	0	0	0	0	Missed
1119	NAPLES	FL	0	0	0	0	0	0	0	Missed
1138	MADISON	WI	1	1	1	1	1	1	1	Visited
1159	NEW TAZEWELL	TN	0	1	1	1	1	1	0	Visited
116	Vivian	LA	0	0	1	1	0	1	0	Visited
1166	ELIZABETHTOWN	NC	0	0	0	0	0	0	0	Missed
117	BROKEN BOW	OK	0	0	0	0	0	0	0	Missed
1175	FLAGSTAFF	AZ	0	0	0	0	0	0	0	Missed
1189	BARBOURVILLE	KY	0	0	0	0	0	0	0	Missed

I created the Missed/Visited formula whish sort of gives me what I need, except when I filter to missed (That is all we care) everything becomes "Missed" even the stores that were visited the other days. Not sure if its possible to create a table that has all stores that were truly missed for the week and this data would change daily as the updates come through. 

This is the formula I have for Visited/Missed 

Visited/Missed= Calculate( IF( Date>1, "Visited", Calculate(IF(Date=0,"Missed"))))

Thank you all! 

[Anonymous]

Hi  @Cio , 

Have a good day. Have you resolved the issue? If the issue persists, could you provide sample data?

Now I know that "Date" is the day of the week from your reply. Howerver I still don't know what the table structure is like.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Best Regards,

Wearsky

[HotChilli]

You've gone nuts with the 'calculate' keyword.

Let's start again.

'Visited/Missed' is a calculated column?

What does it refer to ? A specific date?
"I would like to be able to create a chart that shows stores with "Missed Visit" for the week." What would this look like?

[Cio]

Yes sorry, Visited/Missed is a calculated column. 

The date is for the dates in the week. We are looking one week at a time and the stores have projects that run daily. 

And this is what it would look like. 

Store #	City	State	Missed Visits
3090	ROCKLIN	CA	Missed
4147	MORRISVILLE	NC	Missed
4415	El Paso	TX	Missed
5007	VACAVILLE	CA	Missed
5603	DOWNEY	CA	Missed
5627	GRESHAM	OR	Missed
5990	WICHITA	KS	Missed
1063	GENEVA	AL	Missed
1067	HALLETTSVILLE	TX	Missed
1095	GLENWOOD SPRINGS	CO	Missed
1119	NAPLES	FL	Missed
1166	ELIZABETHTOWN	NC	Missed
117	BROKEN BOW	OK	Missed
1175	FLAGSTAFF	AZ	Missed
1189	BARBOURVILLE	KY	Missed