Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Naverie
Helper I
Helper I

Dividing and applying the value to another

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

SiteTotal Miles
Site11000
Site22000
Site3

3000

Site45000

 

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

 

2 REPLIES 2
amitchandak
Super User
Super User

@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.

 

Naverie_0-1618235936477.png

 

Naverie_1-1618236081550.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors