cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alonlon
Regular Visitor

How to selectively multiply tables

I have two tables : 

FIrst with total tons per year per category 

the Second one is

Goals per year per category in %. 

 

How do i create a messure or a third table with the multiplication of the appropriate aggregate per year in the first table with the corresponising % goals in the second one to get the Goals per year per category in Tons? 

 

below is a a matrix representation of the 2 tables (the first one is already summing the appropriate aggregates)  

 

image.png 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @Alonlon,

So you mean to summarize two visualizations to one? If these visuals are used the same data table field as category, you can create a measure to multiply these value fields. 

For the total level calculations, you may need to add some conditions and filters to handle multiple aggregate calculations. Please check the following blog to know more about these:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @Alonlon,

So you mean to summarize two visualizations to one? If these visuals are used the same data table field as category, you can create a measure to multiply these value fields. 

For the total level calculations, you may need to add some conditions and filters to handle multiple aggregate calculations. Please check the following blog to know more about these:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

DataInsights
Super User II
Super User II

@Alonlon,

 

If the first matrix is showing [Measure1] and the second matrix is showing [Measure2], then you should be able to create Measure3:

 

Measure3 = [Measure1] * [Measure2]

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors