Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@Naverie ,Can you share sample output in table format?
So the Central total needs to be divided by 3 and then added to each other the other sites.
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
38 | |
21 |