Create a measure that refers to a specific field in a column

[smmoore34]

I have  the following table with (2 columns)

Year   # Incidents

2022  98756

2023  12354

2024   64789

The  year is linked to my other tables. When I filter on year I want to have a measure to use in a card that shows the # incidents in that year. 

[Kaviraj11]

Can you share the PBIX File?

I need more details to understand the data type as well. Please elaborate it

[smmoore34]

I beleive I have figured this out. Thank you for your assistance, I'll accept your first solution.

[Kaviraj11 · Accepted solution]

Total Incidence = 

var _selecteddate=FIRSTDATE('Calendar'[Date])

return CALCULATE(SUM(Tablename[# Incidents])+0,TREATAS({_selecteddate},'Calendar'[Date]))

[smmoore34]

I'm not clear on what to enter for the Calendar'[Date]).

My "main_table" has a column called 'Year' which is extracted from a Date field in this table. 

This 'year' column is linked to my table called "incident_counts" that has the following columns:

Year   # Incidents

2022  98756

2023  12354

2024   64789

If the data is filtered on the year 2022 for example, I want a measure that will return the value of '98756'.