cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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?
Screenshot_1.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: How to calculate Dynamic minimum without a comparison period?

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.

1.PNG

Best Regards,
Angelia

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: How to calculate Dynamic minimum without a comparison period?

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.

1.PNG

Best Regards,
Angelia

View solution in original post

Highlighted
Microsoft
Microsoft

Re: How to calculate Dynamic minimum without a comparison period?

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors