Forum Discussion

Dima_R's avatar
Dima_R
Regular Visitor
8 years ago
Solved

How to calculate Dynamic minimum without a comparison period?

Hello everyone!

I have a measure of the minimum sales value:
MIN Sales =
VAR t = MINX(CALCULATETABLE(SUMMARIZE('Calendar';'Calendar'[YearMonth];"value";[Sales]);ALLSELECTED('Calendar'));[value])
RETURN IF(ISBLANK([Sales]);BLANK();t)

Tell me please, how to make a filter that will remove the month of comparison?

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Dima_R,

    In the Visual level filters, please set your measure is not blank(highlighted in yellow background) as follows, and click Apply filter.



    Best Regards,
    Angelia

2 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Dima_R,

    In the Visual level filters, please set your measure is not blank(highlighted in yellow background) as follows, and click Apply filter.



    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Dima_R，

    Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

    Best Regards,
    Angelia