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
rnagallatav
New Member

Need Help with Average Total value

Dear All,

Greetings!

I am loading my calculated data from excel into Power BI. After loading, the "totals row" auto-generated by Power BI is summing the average column values as well. I want the average column to display the value as per my calculation logic. If I disable "totals", all the values from that row are disappearing. I want the A and B columns total to be summed and displayed, but the percentage column needs to consider the total sum values of A and B and calculate the overall average as per Formula in percentage header i.e. =[(160/(160+529))*100]

Current Power BI Output
 ABPercentage
= ((A/(A+B))*100
 92373.66
 52119.23
 144025.93
 11222233.53
 16964.00
 4 100.00
Total160529246.35
Expected Output
 ABPercentage
= ((A/(A+B))*100
 92373.66
 52119.23
 144025.93
 11222233.53
 16964.00
 4 100.00
Total16052923.22

Any suggestion would be greatly appreciated.

 

Thanks in Advance.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@rnagallatav , try like

divide(sum(A),sumx(Table,table[A]+table[B]))

 

Mark column as % column. Not need to multiply by 100

 

Data Format New Rib.png

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@rnagallatav , try like

divide(sum(A),sumx(Table,table[A]+table[B]))

 

Mark column as % column. Not need to multiply by 100

 

Data Format New Rib.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.