Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I have a list of orders for players.
Now, I want to calculate a new table via Dax which gives per player the count of orders.
But after I measured that table i can not link that new table to the main list of orders because there is no table with distinct players. Why? Thought Group By always returns distinct values...
Hi @Anonymous
Could you share some sample data & expected result in text?
e.g.
main list of orders
| players | order |
| ? | ? |
| ? | ? |
new table
| players | count of orders |
| ? | ? |
| ? | ? |
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Please supply your file/data. It's very hard to understand what you are doing without it.
Phil
Proud to be a Super User!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!