Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can i create the below table which is highlighted below. If you refer the screen shot each cell using different formula to fetch the value from above pivot table as shown in the screen shot.
The first table that you see in the screen shot is already been created in power bi using group by. Now I would want to create the 2nd table in power bi.
Please help me how can i create the 2nd table in power bi when the formula varies for each cell.
I cannot the sample PBI as my organization doesn't allow me to share it in one drive.
I can't see where the values in the 2nd table are coming from. The numbers do not seem to match your first table.
Hey @Greg_Deckler Any update on this please? I am yet to find the solution for this. Please let me know if you know the solution for this.
Thanks for your response Greg!
It is coming up from first table only. You were not able to see that since it is present in the screenshot but it is available in the actual data.
User | Count |
---|---|
87 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |