Get Latest Date having sales greater than 1

[Anonymous]

I am looking for dax to get Latest Date having sales. 

Dax should get last date having sales amount greater than 1. 

Example 1:

data           Sales    Output 

1/4/2021               1/2/2021

1/3/2021

1/2/2021    2

1/1/2021    4

Example 2:

data           Sales    Output 

3/4/2021               2/2/2021

2/3/2021

2/2/2021    2

2/1/2021    4

[amitchandak]

@Anonymous , Try a measure like

maxx(filter(allselected(Table), Table[Sales] >1), Table[Date])

[Anonymous]

I have Date in differnt dimention table and sales count in fact table. this dax will not helping. 

I am getting this below error:

Too few arguments were passed to the IF function. The minimum argument count for the function is 2.

[amitchandak]

@Anonymous , if you date table

maxx(filter(allselected(Table), Table[Sales] >1), Date[Date])

But where is if ?

[Anonymous]

Error as below.

A single value for column 'Date' in table 'DIM Date' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

This no If statment in it. Please see the above screen shot. Date is differnt table and sales in differnet table.

[amitchandak · Accepted solution]

@Anonymous , sorry, try like

calculate(max(Date[Date]),filter(allselected(Table), Table[Sales] >1))