Exclude 0 from MINX Result

[bernate]

Hello all, 

I'm trying to get the lowest sum sales value of all days in a month. So in the example below I want to display 5,759 as the value in a card, not 0.

Here is the DAX formula I'm using. It returns the correct result since 0 is the min value, but is there some way I can exclude 0 from the calculation so it jumps to the next minimum value (5,759)?

=MINX(SUMMARIZE('Sales Data','DateTable'[CalendarDt],"Total Sales",SUM('Sales Data'[Daily Sales])),[Total Sales])

[Ashish_Mathur]

Hi,

Does this measure work?

Measure = MINX('DateTable',[Total Sales])

If it does not work, then share the download link of the PBI file.

[Ahmedx · Accepted solution]

pls try this

= MINX( FILTER(
   SUMMARIZE('Sales Data','DateTable'[CalendarDt],"Total Sales",SUM('Sales Data'[Daily Sales])),[Total Sales]>0)
,[Total Sales])

[bernate]

Thank you so much, I knew I was overlooking something and I completely forgot about the filter function.