Help with top 50 products by location

[edavilaamerivet]

Good day community

I was hoping to see if there's someone who can help me as I can figure out how to make this work.

I need to have a visual were each of my locations can show the top 50 revenue codes by type of service

Example

Location 1

Service top 50 

Inventory top 50

diagnostic top 50

if this something that can be done 

Transaction Table

the total amount for the revenue

total qty for the qty (for use of top 50)

Code Table

codes [code] for the number of SKU

standarizedcodetype is for the group

Thank you

[v-alq-msft · Accepted solution]

Hi, @edavilaamerivet 

Based on your description, I create data to reproduce the scenario.

Transcation:

Table:

You may go to ‘Modeling’ area and create a what if Parameter.

You can create a measure as follows.

rank =

IF (

    RANKX (

        SUMMARIZE (

            FILTER (

                ALLSELECTED ( 'Transcation' ),

                RELATED ( 'Table'[codetype] ) IN FILTERS ( 'Table'[codetype] )

            ),

            Transcation[Location],

            'Table'[codetype],

            "total", SUM ( Transcation[Revenue] )

        ),

        [total],

        CALCULATE ( SUM ( Transcation[Revenue] ) ),

        DESC,

        DENSE

    ) <= [TOPN Value],

    SUM ( Transcation[Revenue] ),

    BLANK ()

)

Result:

If I misunderstand your thought, please show me your sample data and expected result. Do mask sensitive data before uploading. I am glad to solve the problem for you.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490