Forum Discussion

YOSIEMPREYO12's avatar
YOSIEMPREYO12
Frequent Visitor
1 year ago
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...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    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

  • alena2k's avatar
    alena2k
    1 year ago

    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]))
v-dineshya's avatar
v-dineshya
Community Support
1 year ago

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's avatar
v-dineshya
Community Support
1 year ago

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