Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
6 years ago
Solved

All filter

Hello - I suspect there is a easy solution - that is not coming to me right away.   VAR YMinValue = MINX(VALUES('CALENDAR'[Year]),CALCULATE([ItemPurchaseDollars]))   I have a year slicer on the...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Dellis81 

     

    I believe what you are looking for is

     

    CALCULATE(MIN([ItemPurchaseDollars]), ALLEXCEPT('CALENDAR'[Year]))
(OR)
CALCULATE(MINX([ItemPurchaseDollars]), ALLEXCEPT('CALENDAR'[Year]))

     

    Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!

     

    Regards,
    Pranit

     

az38's avatar
az38
Community Champion
6 years ago

Hi Dellis81 

maybe 

CALCULATE(MIN([ItemPurchaseDollars]), ALLSELECTED('CALENDAR'[Year]))

 ?