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
Microsoft
------------------------------
Original Message:
Sent: Mar 18, 2019 09:05 AM
From: Kenneth Nielsen
Subject: Procentage of total in a Top 5 report
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!
------------------------------
Kenneth
------------------------------