Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm new to Power BI and haven't had any training so apolygises if the answer is obvious.
I have a set of data
| Site | Total Miles |
| Site1 | 1000 |
| Site2 | 2000 |
| Site3 | 3000 |
| Site4 | 5000 |
The total for Site4 needs to be split between the other 3 sites. The data is being pulled from a SharePoint list so needs to be dynamic as it will constantly be updating as well as being able to be shown on different visulations by site and also by user.
I know how I'd do it in SQL but no idea what DAX syntax I need to use.
Thanks in advance
So the Central total needs to be divided by 3 and then added to each other the other sites.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |