Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Raaassotto
Helper I
Helper I

Dax table formula for top products sales for every seller

I need help to wright DAX formula to make a table witр top 2 selling products for every seller. The input data tabler has the following form:

ProductsSellerSales
Product1Seller15000
Product2Seller15539
Product3Seller15892
Product4Seller15872
Product5Seller29285
Product6Seller24928
Product7Seller25928
Product8Seller29287
ProductN…SellerN…9284
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Raaassotto 
Please try

Top 2 Products =
GENERATE (
    VALUES ( 'Table'[Seller] ),
    TOPN (
        2,
        SUMMARIZE (
            CALCULATETABLE ( 'Table' ),
            'Table'[Product],
            "Total Sales", SUM ( 'Table'[Sales] )
        ),
        [Total Sales]
    )
)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Raaassotto 
Please try

Top 2 Products =
GENERATE (
    VALUES ( 'Table'[Seller] ),
    TOPN (
        2,
        SUMMARIZE (
            CALCULATETABLE ( 'Table' ),
            'Table'[Product],
            "Total Sales", SUM ( 'Table'[Sales] )
        ),
        [Total Sales]
    )
)
johnt75
Super User
Super User

SQLBI have a great article on showing top products by category.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors