How to calculate Dynamic minimum without a comparison period?

[Dima_R]

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?

[v-huizhn-msft]

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

[v-huizhn-msft · Accepted solution]

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