Microsoft BI Professionals Denmark

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Procentage of total in a Top 5 report

  • 1.  Procentage of total in a Top 5 report

    Posted Mar 18, 2019 09:05 AM

    Hi, I need your help!

    I have a list of 100 customers, where I just want to show the Top 5 in a tabel. No problem here. My problem is that I would like to show each of the top 5 customers revenue as % of the all 100 customers revenue. Sure that one of you know the answer - thanks!


  • 2.  RE: Procentage of total in a Top 5 report

    Bronze Contributor
    Posted Mar 19, 2019 04:48 AM
    Hi Kenneth

    Take at look at this article; Dynamic TopN & Ranking in Power BI
    Microsoft remove preview
    Dynamic TopN & Ranking in Power BI
    Let's assume we have data about projects, and we want to rank the projects by budget, so that if we filter the data by some criteria (i.e. region, country, or some other classification) the ranking recalculates for the new scope. We also want some metrics calculated for the TopN projects, i.e.
    View this on Microsoft >

    It does not provide the answer 100%, but it has the building blocks you need :-)

    Lars Andersen