Forum Discussion
value where date= min(date)
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...
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
Or maybe a duplicate table which is just the "window dressing" for the visual, but is not affected by the slicer.