Retrieve values based on another column value

[MarioCadena]

I have tried to retrieve the ETA date independently when the inserted date is the earliest and when it is the latest, then calculate the variation in days.

When I use the following formula:

CALCULATE(values(Combined[ETA Date]),FILTER(ALL(Combined[DW_InsertedDateTime]),Combined[DW_InsertedDateTime]=max(Combined[DW_InsertedDateTime])))

I got the following message!

Any idea how to solve this issue? Thank you!

[amitchandak]

@MarioCadena , you can not use values there

CALCULATE(Max(Combined[ETA Date]),FILTER(ALL(Combined[DW_InsertedDateTime]),Combined[DW_InsertedDateTime]=max(Combined[DW_InsertedDateTime])))

or

CALCULATE(max(Combined[ETA Date]),FILTER(ALL(Combined[DW_InsertedDateTime]),Combined[DW_InsertedDateTime]=max(Combined[DW_InsertedDateTime])),values(Combined[ETA Date]))

[MarioCadena]

It worked, thank you.

Also, could you tell me how to change it; so, the calculation is not affected by filters?

Regards,

Mario

[v-xuding-msft · Accepted solution]

Hi @MarioCadena ,

You could edit interaction in Format.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions