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.
I am building a matrix in PBI using a PowerPivot Excel report as a template. I have a few columns I don't know how to do in PBI. I'll just mention one in this post to keep things simple.
I was going to upload a pic, but this message tool is pretty clunky so what I have below will do.
I have the Quadrant , Payor Group and Trips fields already. I need a column to return each company's % of the total trips, as in the last column on the right.
Can anyone help?
Thanks,
Michael K
Quadrant | Payor Group | Trips | % of Trips |
High & Fast | COMPANY | 7,786 | 42.3% |
High & Fast | COMPANY 1 | 2,008 | 10.9% |
High & Fast | COMPANY 2 | 780 | 4.2% |
High & Fast | COMPANY 3 | 619 | 3.4% |
High & Fast | COMPANY 4 | 479 | 2.6% |
High & Fast | COMPANY 5 | 466 | 2.5% |
High & Fast | COMPANY 6 | 435 | 2.4% |
High & Fast | COMPANY 7 | 350 | 1.9% |
High & Fast | COMPANY 8 | 330 | 1.8% |
High & Fast | COMPANY 9 | 258 | 1.4% |
High & Fast | COMPANY 10 | 232 | 1.3% |
High & Fast | COMPANY 11 | 224 | 1.2% |
High & Fast | COMPANY 12 | 212 | 1.2% |
High & Fast | COMPANY 13 | 192 | 1.0% |
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |