Forum Discussion
Solved
Primera compra
Buen día Tengo una tabla con las siguientes columnas, fecha, local, compras. Hay también un filtro de fechas que no puedo quitar Necesito una medida o algo que me permita mostrar cuál fue la co...
Hi YOSIEMPREYO12 ,
Thank you for reaching out to the Microsoft Community Forum.
This measure ignores all filters, including date filters
First Purchase Date =
CALCULATE(
MIN('Table'[Date]),
ALL('Table')
)This measure ignores filtering only on the Date column
First Purchase Date =
CALCULATE(
MIN('Table'[Date]),
ALL('Table'[Date])
)If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank youYou cannot show first date in the Date column, because it is being filtered. You have to use different column or visual to display it. You can show first Purchase Amount is the separate column as well:
First Purchase = CALCULATE(SUM('Table'[Amount]),
TOPN(1, ALL('Table'), 'Table'[Date], ASC),
'Table'[Location] = SELECTEDVALUE('Table'[Location]))
Si funcióna
Gracias