Sure. I've created this .pbix file from your example data, showing off a few ways to calculate this value. I made up some names for your fields, since the screenshot you provided doesn't give one.
In the Fields pane to the right of the screen, you should see the table. Right click the table you want this Measure to be associated with (the association to a specific table doesn't actually DO anything, but it's useful in keeping measures organized with the table they calculate from), and select New Measure.
From there, you will get a text box at the top of the screen appearing. You would put this code into that text box and change the tables/fields in the code to have names that match the ones in your dataset. Once the measure is created, you can drag it into a card visual like any other field.
In the example file I linked, you can click any of the measure I created (they have a little calculator icon in the fields pane) and see the code used to create them across the top of the screen. I think I also misread your requirements (again) in my excitement about having two dates to compare. Looking at which dates are red/black, I've realized that you actually want to count dates that are 5 years or older than TODAY, instead of some other date. I've created the example file accordingly.
The easy way to figure out how long ago something was is to use the DATEDIFF function in DAX. However, it only gives whole numbers, and rounds up, so any rows that are 4.5+ years old round up to 5, which would be counted in the wrong category. You could use DATEDIFF and have it count the days instead of the years, and do the math of desired years * 365 days yourself, but that doesn't account for leap years, and looks messy.
Days Since = DATEDIFF(SELECTEDVALUE(AuditInfo[Founding Date]), TODAY(), DAY)
Years Since = DATEDIFF(SELECTEDVALUE(AuditInfo[Founding Date]), TODAY(), YEAR)
The clean way to do it is to use the YEARFRAC function in DAX. This gives you a decimal value for year difference, that doesn't automatically round up. This looks much better, and can be easily used to get an accurate answer to "is this date older than 5 years from now?".
Years Since (Frac) = YEARFRAC(SELECTEDVALUE(AuditInfo[Founding Date]), TODAY())
Now that we've determined the best way to get a clean result, we need to count the rows where this is measure is greater than or equal to 5. However, measures don't exist in a row on a table, they're calculated on the spot in the current context. You can read more about that here. However, there's a handy function called SUMMARIZE that can be used to create a temporary table that we CAN count the rows of.
This takes the table AuditInfo, groups all the rows by the same [Location ID], and adds a field called Years Since Founding Date that is populated by the measure [Years Since (Frac)]. It then filters this virtual table where the Years Since Founding Date is greater than or equal to 5.
CountOlderThan5Yrs =
COUNTROWS(
FILTER(
SUMMARIZE(AuditInfo, AuditInfo[Location ID], "Years Since Founding Date", [Years Since (Frac)]),
[Years Since Founding Date] >= 5.0
)
)I added a [Location ID] to the table (it's just a number that's unqiue to each row), so that when I used SUMMARIZE, I could guarantee uniqueness of each row. I did this because if some locations had the same Founding Date, they would get grouped into one entry and only count once in the measure. You can see the results of this in the card to the bottom right. For your real data, you can either add an index, or use a pre-existing field that's unique to each row to group by.
I also set up conditional formatting on the Founding date, just like you did in Excel. You can right click the Founding Date field in the Values bucket of the Visualization pane to see how I set that up.
Hopefully that long winded explanation helps you solve your problem. If you have further questions, feel free to ask.
