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 |
