TopN Share of total

[JLiljedahl]

Hi 

I have "inherited" a PBI report from a former collegue with a funtion of ranking topN customer by sales

I now need to do the same thing but instead of sales value in € I want to display sales share per customer in %. Anyone who could support me in rewrite below code for this application?

Sales Amt =

Var SalesOfAll=

    CALCULATE([Total Sales],REMOVEFILTERS(GroupCustomer[GroupCustomer]))

Return

    IF(

        ISINSCOPE(GroupCustomer[GroupCustomer]),

        VAR ProductsToRank = 'TopN'[Value for TopN]

        VAR IsOtherSelected = SELECTEDVALUE(GroupCustomer[GroupCustomer])="Others"

        VAR ProductsWithSalesAmt =

            ADDCOLUMNS(

                ALLSELECTED(GroupCustomer[GroupCustomer]),

                "@Amt", [Total Sales]

            )

        VAR Top3Prods = TopN (ProductsToRank,ProductsWithSalesAmt,[@Amt])

        VAR SalesOfTop3 = SUMX(Top3Prods,[@Amt])

        VAR Result = IF(IsOtherSelected,SalesOfAll-SalesOfTop3,[Total Sales])

        Return Result,

        SalesOfAll

    )

[Ritaf1983 · Accepted solution]

Hi @JLiljedahl 
Please refer to the linked tutorial :

https://www.youtube.com/watch?v=jyKAxKSHBTk

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