Calculate/Filter to get the date when to x(value)

[BlastS]

I got this columns

Date                                   columnX               Output Expect 

02/02/2013 12:00:00            0                       02/02/2013 12:10:00

02/02/2013 12:10:00            1

02/02/2013 12:20:00            0 

02/02/2013 12:30:00            0

I go to columnX i can make a count (to get all = 1 ), but instead of showing the count number i want to display the date where columnX is equal to 1 , i already tried filters and calculate but dont know how can i make this.

Where is 1 should be displayed the date

[parry2k · Accepted solution]

@BlastS try this

Date Measure = 
CALCULATE ( MIN( Table[Date]), FILTER( ALL( Table ), Table[column] = 1 ) )

[themistoklis · Accepted solution]

@BlastS

Or this:

Measure = CALCULATE(MAX(Table[Date], Table[columnX]=1)

[v-chuncz-msft · Accepted solution]

@BlastS,

See https://www.sqlbi.com/articles/filter-arguments-in-calculate/ to learn more.

[themistoklis · Accepted solution]

@BlastS

Or this:

Measure = CALCULATE(MAX(Table[Date], Table[columnX]=1)

[parry2k · Accepted solution]

@BlastS try this

Date Measure = 
CALCULATE ( MIN( Table[Date]), FILTER( ALL( Table ), Table[column] = 1 ) )