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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
TeeGee
Helper II
Helper II

Possible to write a ~SUMMARY on [Table1] with calculations based on an unconnected [Table2]?

I have an unusual scenario that I think should be possible, but due to its unusual nature I'm having trouble finding a similar example.

 

Basically, what I'm trying to do is create a calculated table that is a secondary version of [CBF AppTech Impact], but with the addition of some columns containing aggregate values from [CBF Analysis] based on fields: 

Company, Department, CBF ID

 

I already have Measures for all of these calculations, so ideally I could just reference those in this formula.

 

I've been looking at SUMMARIZE, CALCULATETABLE, TREATAS, and documentation on various join type, but anything I've tried I can't get to work (typically a syntax error due to attmpting to do something invalid).

 

Is what I'm trying to do even possible?

If someone could even tell me the fundamental function (SUMMARIZE, CALCULATETABLE, etc) I should be starting with, that would be a huge help!

 

2019-10-03 13_00_11-2019-10-02 13_51_07-BDIA - Power BI Desktop.png - Greenshot image editor.png

0 REPLIES 0

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.