Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have this situation and I need help.
I have requirments to get a number of items with % of grand total :
I have an Items with sales. I need to sort sales per item desc. After that i need to calculate % of grand total. (column F)
After that I need to get Number of ItemNo by % of grand total.
I need to count number of ItemNo summing % of grand total ( column F ). When I got forexample 50%, i need to count nubmer of items. Forexample summing % from top and after 20 items I got 50% i need to put in 50 % of grand total number of 20 items. After that I need to sum again from top until 75% of grand total, and now i have maybe 37 items.
How i can calculate this?
@sima_ue031 Probably need a disconnected table and then a measure that incorporates your logic for what to count. Interesting problem given the need for sorting. Would like to take a closer look but would need sample data posted as text or a link to a sample file.
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |