Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Need DAX help!
I am looking for Top5 customer and their top unit in column.Apart from the Top 3 units which are in column I want to add all sales in Other column and then a Total Sales column. I am trying to create dax function but its not working.
Below is the sample data set
Customer | Unit | Sales |
AA | SCM | 500 |
AB | Procurment | 600 |
AC | Sales | 300 |
AD | Field | 209 |
AA | Marketing | 948 |
AB | Procurment | 305 |
AZ | Marketing | 382 |
AF | Services | 633 |
AK | Field | 993 |
AN | Procurment | 244 |
AD | Field | 362 |
AK | Marketing | 750 |
AD | Procurment | 250 |
Expected Output would be like
Top5 customer in row, Top3 unit in column(having the sales value for that unit) and "other" column (Having sales sum except the top3 value sale) and Grand total(Sum of all sales) at the end.
Customer | Field | Marketing | Procurment | Other | Grand Total |
AA | 948 | 500 | 1448 | ||
AB | 905 | 905 | |||
AD | 571 | 250 | 250 | 821 | |
AF | 633 | 633 | |||
AK | 993 | 750 | 1743 | ||
Requesting you to do the needful.
Regards
Uphar
@Anonymous - Take a look at the Complex Filter, it has a matrix example and similar use case to what you are looking to do. Not exact, but similar. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
I am able to fetch the top 3 unit using below DAX and top5 suppliers by using filter and TopN option. The only issue is with Other column (In which I need sum of all sales except those values which are available in top3 units).
If you can help me how I can create other column in matrix. It would be a great help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |