Primera compra

[YOSIEMPREYO12]

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 compra sin importar el filtro que esté usando

Se podrá?

Gracias

[v-dineshya · Accepted solution]

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 you

[YOSIEMPREYO12]

Si funcióna 

Gracias

[v-dineshya · Accepted solution]

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 you

[v-dineshya]

Hi @YOSIEMPREYO12 ,

Thank you for reaching out to the Microsoft Community Forum.

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 you

[danextian]

Hi @YOSIEMPREYO12  As always, please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

[YOSIEMPREYO12]

No tengo mucho para mostrar son solo 3 columnas

Necesito la primera fecha de compra sin importar el filtro que tenga puesto

Solo eso

Gracias

[alena2k]

Yes, it is possible. You need to build DAX measure using CALCULATE and filter ALL(Table[Dates])

Links to review:
https://learn.microsoft.com/en-us/dax/all-function-dax
https://learn.microsoft.com/en-us/dax/calculate-function-dax

[YOSIEMPREYO12]

Pero eso no me trae la primera fecha

Falta algo me parece

[alena2k · Accepted solution]

You 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]))