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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
PBI5851
Helper V
Helper V

making a calculation based on the sum

Hello,

My raw is like below. 

TMShip CountRegionRD
John5EastSmith
Smith7NorthTony
Steve12SouthSmith
Mary15WestTony
Mark20WestJackie
Jim17NorthJackie
Tom25NorthTony
Brian30EastSmith

 

The expectation is to have three different tables. 

Table1

 

 

RDSum of Ship Count
Jackie37
Smith47
Tony47
Grand Total131

 

Table 2:

TMShip Count%
Brian23%
Jim13%
John4%
Mark15%
Mary11%
Smith5%
Steve9%
Tom19%

 

Table 3:

TMNewCal
Brian30
Jim17
John5
Mark20
Mary15
Smith7
Steve12
Tom25

 

New cal = Ship Count% * Grand Total from Ship Count (table1)

Table 1 and 2 are straightforward and i'm able to achieve this. But table 3 is where i keep getting stuck as I am unable to create a measure to capture the total as a complete value to make the calculation., while allowing the numbers to change based on any filter/slicers that can be applied. Any suggestions please. 

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

What is the confusion/problem?  Jsut drag TM and Ship count to a Table visual.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
CoreyP
Solution Sage
Solution Sage

You can use ALLSELECTED to remove context to get a total calculation to use by each row. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors