The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
Following up on an earlier thread which was graciously resolved by @MFelix , I'd like to ask a different question. How does one report the top x number of customer names against a regional sale list. In my case it's about components and products consuming those. The associated model and data is here
https://drive.google.com/file/d/1K5PMiLYH3X5zZBWmb0JikgXEgbptZJZ2/view?usp=drivesdk
I'm looking to add a measure that reports the names of the products in the rows for each component indicating the top 2 (or less) products associated with each component's consumption.
Solved! Go to Solution.
Found a solution using this tip posted here
https://community.powerbi.com/t5/Quick-Measures-Gallery/Concatenated-list-of-top-items/td-p/237585
Found a solution using this tip posted here
https://community.powerbi.com/t5/Quick-Measures-Gallery/Concatenated-list-of-top-items/td-p/237585
User | Count |
---|---|
15 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |