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.
Hello - I am a beginner and am learning on my own and I really appreciate all the great knowlegde and support here. I have a data table as shown below with partid and fundid. I created a measure to count the number funds held by each partid. called CountFundsHeld (CountFundsHeld = COUNT(BalanceLoad[FundID])). What I now need to count is the number of partid's for each number of funds (CountFundsHeld). i.e.
#Funds | #PartId's |
1 | 0 |
2 | 1 |
3 | 0 |
4 | 2 |
5 | 3 |
etc...
My only limitation is that i want to do this without using a calcualted column. See sample data.
PartID | FundID | Value |
567903696 | 26572 | 1795466.86 |
580067790 | 26572 | 1151028.66 |
628312818 | 26573 | 1110908.8 |
722186409 | 26575 | 1009587.34 |
693119004 | 26224 | 837533.15 |
601494264 | 25909 | 760576.36 |
456277530 | 26570 | 709610.98 |
721491192 | 26575 | 640558.87 |
784738809 | 26576 | 617580.44 |
717572547 | 26575 | 611810.78 |
512952069 | 25909 | 571732.94 |
598223175 | 7563 | 530069.72 |
603661425 | 26573 | 524099.67 |
532314804 | 26572 | 520168.34 |
562759644 | 26572 | 503297.71 |
649022550 | 26574 | 483795.01 |
672862677 | 26574 | 474723.89 |
322377465 | 26570 | 473814.67 |
745235100 | 26576 | 408157.93 |
647173746 | 25909 | 407664.03 |
764409660 | 26576 | 402921.11 |
489882543 | 26571 | 399239.58 |
471712578 | 26571 | 389165.84 |
598721319 | 26573 | 388098.12 |
675643560 | 26574 | 371190.47 |
730616961 | 26575 | 355842.75 |
778007667 | 26576 | 347468.89 |
612711471 | 25909 | 338999.06 |
310419717 | 26570 | 314007.33 |
514073298 | 26571 | 312775.69 |
636709437 | 26574 | 304044.7 |
600965280 | 26573 | 298613.43 |
712364007 | 26224 | 298491.12 |
759991365 | 26576 | 296457.72 |
531367932 | 25909 | 287726.54 |
704385108 | 26575 | 284977.73 |
702532290 | 26575 | 281122.03 |
602606982 | 26573 | 275664.04 |
669463845 | 26224 | 270902.99 |
625180473 | 26573 | 264813.33 |
750902085 | 26576 | 263985.53 |
842226441 | 26577 | 260437.88 |
638710050 | 7581 | 244301.53 |
724653489 | 7563 | 243247.37 |
598621878 | 26573 | 225659.99 |
620258970 | 25909 | 215206.03 |
797761185 | 26577 | 211057.8 |
764409660 | 26578 | 203063.66 |
764409660 | 26577 | 202485.18 |
711266214 | 26575 | 201734.2 |
582944319 | 26573 | 200944.08 |
433482876 | 26570 | 198098.27 |
506941023 | 26571 | 193352.55 |
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Ashish_Mathur - Wow - that is exactly what I need. Very elegant solution. you rock!
You are welcome.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |