You have been provided with a dataset that contains information about customers and their revenue from purchasing products. Your goal is to identify the key customers who contributed to 80% of the revenue but accounted for only 20% of the business.
When we talk about “20% of the business,” we’re referring to a proportion or portion of the overall business. It represents a specific fraction of the total business activity or value.
Imagine a hypothetical business, let’s say it’s a retail store. The business can have different aspects or components, such as customers, revenue, products, or any other relevant measure. In this case, when we say “20% of the business,” we’re looking at a specific part of the business that is responsible for a certain percentage of its overall activity or value.
You should provide a visual or a table showing the list of customers who meet the criteria mentioned above.
Good luck with the challenge!
Submission
Load the supplied data file into a new Power BI file, create your solution, and reply to this post. Upload a screenshot of your solution along with the DAX measure. Please format your DAX code and blur it or place it in a hidden section. You can do this by clicking on the “gear” icon above.
Period
This workout will be released on Thursday, May 11, 2023, and will end on Sunday, May 14, 2023. But you can always come back to any of the workouts and solve them.
DAX _16 Top 20 Percent.pbix (532.2 KB)
