Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
Being a new bie to PBI Need help to arrive at correct measure to take in to account the bridging table .
Recreated my actual case with simple sample data.
Two fact tables,Three dim tables and a Bridge table.
Bridge table has n to 1 relationship as well as 1 to n relation ship between ID1 and ID2
My current measure does not take in to account the relation ship while calculation as it still calculates the values for independent IDs  and not taking the ID  mapping to account. Expected correct values given in red after aggregation.
https://drive.google.com/file/d/1NwijYKBDzng82mm6jXpthB8SkWAG1OJo/view?usp=drive_link
Enclosing the PBIX sample file.
Deeply appreciate your support.
Thanks.
Solved! Go to Solution.
Yeah, sort of. The good thing about TREATAS is that it works (better) without joins.
@lbendlin 
Request to confirm whether the below approach is right in current context
Energy_per_cum(Rev1) = 
CALCULATE(
VAR Units =
CALCULATE(
    [Energy (Units)],
    TREATAS(
        SUMMARIZE(
            Bridge_Table,Bridge_Table[ID1]),
            Fact_Table1[ID1])
)
VAR Flow_cum  = 
CALCULATE(
    [Flow (Ltrs)],
    TREATAS(
        SUMMARIZE(
            Bridge_Table,Bridge_Table[ID2]),
            Fact_Table2[ID2]
    )
)
VAR Units_per_Cum = DIVIDE(Units,Flow_cum)
RETURN Units_per_Cum
)
					
				
			
			
				
			
			
				
			
			
			
			
			
			
		Yeah, sort of. The good thing about TREATAS is that it works (better) without joins.
Are you familiar with the TREATAS function?
@lbendlin -Sorry i need to explore. If you can suggest that measure,will be of great help. Thank u for your response
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
            | User | Count | 
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | 
| User | Count | 
|---|---|
| 24 | |
| 11 | |
| 11 | |
| 9 | |
| 8 |