Forum Discussion
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 compra sin importar el filtro que esté usando
Se podrá?
Gracias
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]))
8 Replies
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.
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
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
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 youHi 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
Si funcióna
Gracias
