DAX measure to Calculate Distinct count for first-time listing for the selected period.

[Nelson-Mwangi]

I need your help with a DAX measure to generate a count of distinct first-time listing each brand for the selected period.

My data model is in Power Pivot(I will appreciate a measure that will work in PowerBi & PowerPivot), and when I create a table with Month Name on the columns, each outlet should only be counted once (First time purchase) which is captured on the 'Listing Date" column.

The total rows and columns should reflect the overall distinct count.

The code in the image attached works (got help from Copilot), but I was wondering if there is an alternative that’s easier to follow. 

The relationship between the calendar table and Document Listing table is on "Date' column while the first listing date is on the listing date column.

I'm open to all solutions including the possibility of achieving the result with the date column.

Thank you.

[Nelson-Mwangi]

Unfortunately, this is my first post I'm not allowed to attach files.

The snip below has a sample data  and the relationship - Hope that helps.

[tayloramy]

Hi @Nelson-Mwangi, 

Please see this post for how to provide sample data: 
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Also take a look at this post: 
(1) How to Get Your Question Answered Quickly - Microsoft Fabric Community

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this post as the solution. 

[Nelson-Mwangi]

Customer Code	Customer Name	Brand	ListingDate	Product Code	Salesman	Date	Sales
KE0064975	Fenix Liquors Store, Kitale	Don Julio	01/07/2025	636328	Kitale Counter	01/07/2025	0.17
KE0064975	Fenix Liquors Store, Kitale	Don Julio	01/07/2025	636328	Titus Peter	01/08/2025	0.17
KE0064975	Fenix Liquors Store, Kitale	Don Julio	01/07/2025	636349	Janet Cheruiyot	01/08/2025	0.17
KE0138196	Swam W&S,Kitale	Don Julio	01/07/2025	636349	Titus Peter	01/07/2025	0.5
KE0141961	Bonile wines ktl	Don Julio	01/07/2025	636328	Kitale Counter	01/07/2025	0.33
KE0141961	Bonile wines ktl	Don Julio	01/07/2025	636350	Kitale Counter	01/07/2025	0.17
KE0149467	Lion Liquor Store, Kibomet	Don Julio	01/08/2025	636328	Kitale Counter	01/08/2025	0.17
KE0152923	Kitale Club,Kitale Town	Don Julio	01/08/2025	636349	Kitale Counter	01/08/2025	0.17
KE0152923	Kitale Club,Kitale Town	Don Julio	01/08/2025	636328	Dennis Memba	01/09/2025	0.33
KE0156529	Alaska Bar,Sibanga	Don Julio	01/08/2025	636349	Janet Cheruiyot	01/08/2025	0.17
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Kitale Counter	01/08/2025	0.08
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/07/2025	0.08
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/07/2025	0.17
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/08/2025	0.17
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	763807	Jasron Anyasi	01/08/2025	0.12
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/09/2025	0.17

[v-priyankata]

Hi @Nelson-Mwangi 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Based on my understanding, could you please try the following DAX? It might be helpful.

First-Time Listings =

COUNTROWS(

    SUMMARIZE(

        'Document Listing',

        'Document Listing'[Customer Code],

        'Document Listing'[Brand],

        "FirstListDate", CALCULATE(MIN('Document Listing'[ListingDate]))

    )

)

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Thanks.

[v-priyankata]

Hi @Nelson-Mwangi 

Thank you for reaching out to the Microsoft Fabric Forum Community.

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[Nelson-Mwangi]

Customer Code	Customer Name	Brand	ListingDate	Product Code	Salesman	Date	Sales
KE0064975	Fenix Liquors Store, Kitale	Don Julio	01/07/2025	636328	Kitale Counter	01/07/2025	0.17
KE0064975	Fenix Liquors Store, Kitale	Don Julio	01/07/2025	636328	Titus Peter	01/08/2025	0.17
KE0064975	Fenix Liquors Store, Kitale	Don Julio	01/07/2025	636349	Janet Cheruiyot	01/08/2025	0.17
KE0138196	Swam W&S,Kitale	Don Julio	01/07/2025	636349	Titus Peter	01/07/2025	0.5
KE0141961	Bonile wines ktl	Don Julio	01/07/2025	636328	Kitale Counter	01/07/2025	0.33
KE0141961	Bonile wines ktl	Don Julio	01/07/2025	636350	Kitale Counter	01/07/2025	0.17
KE0149467	Lion Liquor Store, Kibomet	Don Julio	01/08/2025	636328	Kitale Counter	01/08/2025	0.17
KE0152923	Kitale Club,Kitale Town	Don Julio	01/08/2025	636349	Kitale Counter	01/08/2025	0.17
KE0152923	Kitale Club,Kitale Town	Don Julio	01/08/2025	636328	Dennis Memba	01/09/2025	0.33
KE0156529	Alaska Bar,Sibanga	Don Julio	01/08/2025	636349	Janet Cheruiyot	01/08/2025	0.17
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Kitale Counter	01/08/2025	0.08
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/07/2025	0.08
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/07/2025	0.17
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/08/2025	0.17
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	763807	Jasron Anyasi	01/08/2025	0.12
KE0034887	Sirwo Resort, Kapcherop	Gordons Dry Gin	01/07/2025	716210	Jasron Anyasi	01/09/2025	0.17

[tayloramy]

Hi @Nelson-Mwangi, 

Can you please provide sample data in a usable format (not a screenshot)?

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.