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

     

Anonymous's avatar
Anonymous
Not applicable
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

 

Dellis81's avatar
Dellis81
Post Prodigy
6 years ago

Thank you very much!   After more review this morning - was able to make this particular calculation work.   Your second option is what I needed.

 

What I am trying to do - is convert a dailer sparkline measure into an annual measure.   And this was one of the calculations inside the larger measure.    I am still havig problems - but will open another case - as my original hangup is now fixed.

 

Thank you again!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Dellis81 

     

    Great that helped. Can you please mark that post as Solution!

     

    Regards,

    Pranit