Forum Discussion

Anders1's avatar
Anders1
Frequent Visitor
6 years ago

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...
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

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