value where date= min(date)

[Anders1]

I need to make a calculated column or a measure that gets the count from the row where the date = min(date).

I also need the count from min date to change based on the filter applied by the user. If the user is filtering so that the 03.01.2019 is the min(date) then the value 654824 should be the "count from min date"

Date Count Count from min date
01.01.2019 951665 951665
02.01.2019 656480 951665
03.01.2019 654824 951665
04.01.2019 508652 951665
05.01.2019 959591 951665
06.01.2019 1205968 951665
07.01.2019 1192514 951665
08.01.2019 1222022 951665
09.01.2019 144865 951665
10.01.2019 291006 951665

[Nathaniel_C]

Hi @Anders1 ,

Min Date Value = CALCULATE(MIN('Table (3)'[Count]),ALLSELECTED('Table (3)'[Date]))

Not sure if this is what you are looking for based on your picture. If you have a visual filter it will not work on a calculated column. The selection defines the visual so the extra rows go away. Off the top of my head, if you had multiple columns, where each value was represented and the visual selected one of those columns, then maybe...but costly.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Nathaniel_C]

Or maybe a duplicate table which is just the "window dressing" for the visual, but is not affected by the slicer.