Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago
Solved

Min Week Selected by Slicer

Please help,

 

I need WeekSel Measure to compute for all rows in visual the minimm week number selected. All I achieved is:

 

WeekSel = CALCULATE(MIN('Calendar'[YearWeekNo]);'Calendar'[Date])

 

https://drive.google.com/open?id=1oCddr2RfUSMK8TZyZodAsc3s7nKHTgXA

 

Thank you

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Fcoatis,

     

    Please update your formula as below.

     

    WeekSel = CALCULATE(MIN('Calendar'[YearWeekNo]),ALLSELECTED('Calendar'))

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

2 Replies