Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi,
I have this relationship between two tables:
The orders are just for country/period, so I want to mantain the same number of orders for each Country/Period/Category when I formulate at DAX.
Some ideas??
Thanks
Hi @sbellidoBI,
The orders are just for country/period, so I want to mantain the same number of orders for each Country/Period/Category when I formulate at DAX.
I'm not very clear about your requirement.
If it is convenient, could you show your expected output, so that we can help further investigate on it?
Best Regards,
Cherry
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 20 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 63 | |
| 56 | |
| 47 | |
| 44 | |
| 37 |