Min of a column, when a variable is zero

[Smackcat]

Hi experts,

I have a complex table, but I have summarized it as the following:

SUMMARIZE(Table,Table[Period],"Sales",SUM(Table[Sales_unit]))

So now I have:

Period	Sales
2023	100
2022	100
2021	0

I want a measure, that shows me the [Period] when [Sales] = 0 (in the example, the answer is 2021). I was trying with minx

MINX(FILTER(SUMMARIZE(Table,Table[Period],"Sales_unit",SUM(Table[Sales_unit])),[Sales] = 0),[Period])

But this measure shows me a dynamic range that is not the wanted result 😞

Any help is appreciated. Thanks

[amitchandak]

@Smackcat , You should use sales in the sum,

MINX(FILTER(SUMMARIZE(Table,Table[Period],"Sales_unit",SUM(Table[sales])),[Sales_unit] = 0),[Period])

of you can use all or allselected

MINX(FILTER(SUMMARIZE(all(Table) ,Table[Period],"Sales_unit",SUM(Table[sales])),[Sales_unit] = 0),[Period])

or

MINX(FILTER(SUMMARIZE(allselected(Table) ,Table[Period],"Sales_unit",SUM(Table[sales])),[Sales_unit] = 0),[Period])