calculating unique count based on a filtered condition

[numaan_99]

i have three columns "term_id_new", "Sale Date" from the same table "Sale Items". Now i want to keep only those "term_id_new" whose first "Sale Date" is 20/12/2023. How to do that in powerbi

sample data: 

term_id_new	Sale Date
BBTN01001	11/26/2023
BBTN01001	12/1/2023
BBTN01001	12/3/2023
BBTN01001	12/5/2023
PBTN01001	12/20/2023
PBTN01001	9/1/2023
PBTN01001	9/1/2023
PBTN01001	9/1/2023
PBTN01001	9/1/2023
LTTN01001	12/20/2023
LTTN01001	9/2/2023
LTTN01001	9/3/2023
LTTN01001	9/8/2023

Expected Output:

term_id_new	Sale Date
PBTN01001	12/20/2023
LTTN01001	12/20/2023

NOTE: please provide me the detailed solution along with the formulae as i am completely noob into powerbi. Please do this for me. I will pray for you.

[Ahmedx]

in this scenario you do not need any measures, the filter will do everything for you

[numaan_99]

but i need to find out minimum of "sale date" for each terminal id. then out of those, i only need to keep terminals IDs whose last date is 20/12/2023. i need to create a separate column for this. and using that column, i will do some calculations in future. please provide me any queiry formulas in detail.

[Vallirajap]

Hii @numaan_99 

Use the below dax:

Count = Count(('Table (4)'[Term_id]))

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you

[numaan_99]

but i need to find out minimum of "sale date" for each terminal id. then out of those, i only need to keep terminals IDs whose last date is 20/12/2023. i need to create a separate column for this. and using that column, i will do some calculations in future. please provide me any queiry formulas in detail.

[Vallirajap · Accepted solution]

Hii @numaan_99,
Based on my understanding, I found the solution below

Try this,

1. Minimum of sael date for each Term_id:

2. Terminal Id for the last date 20/12/2023:

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you.

[numaan_99]

This gives me the solution. i would like to work with you could you please give me your number or any contact to connect

[Vallirajap]

Hii @numaan_99,

I am really happy about your acknowledgement. Thank you for that.

If you have any questions, mention me in your post to ask a question in the community.

In rare cases, connect with me through email.

pvalliraja21@gmail.com

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you