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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
MercedesAlpha1
Frequent Visitor

Visualisation not showing correct results from multiple tables

Hi, so im reletively new to powerbi but seem to be making good ground.

 

However I have an issue where im trying to have a visual bring back results from two different tables

 

Ive screenshot the relationships below. Basically Im looking to have a table visualisation which shows the category and the the contract value and the amount spent against the contract. The Contracts are in the register and the spend in the spend table. To link them I had to create a intermidary table which had the supplier account code which is in both tables multiple times (I could link the tables directly because of this as multiple contracts have the same supplier account code and multiple invoices are listed in the spend table with the account code.

 

In the output example below im taking the category level 1 field from the contracts table, the total contract value from the contracts table and the amount excluding vat from the spend table. However the figure reported from the spend table is the total for all invoices.

 

How do i correct this so i can see the contract value and spend by category?

 

Thanks

 

 

Relationships.pngResults.png

1 ACCEPTED SOLUTION

In the example I provided:

Measure 32 =
var _supplier = MAX('Table (42)'[Supplier]RETURN
CALCULATE(SUM('Table (41)'[Value]),'Table (41)'[Supplier]=_supplier)

Here we take the supplier information from one table and use it to calculate the corresponding value from the other.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ValtteriN
Super User
Super User

Hi,

Use calculate and modify the filter context:

Example tables:

ValtteriN_0-1722595982714.png

ValtteriN_1-1722596077197.pngValtteriN_2-1722596220782.png

Simple sum won't work:

ValtteriN_3-1722596366660.png

 


However this will work:

Measure 32 =
var _supplier = MAX('Table (42)'[Supplier]) RETURN
CALCULATE(SUM('Table (41)'[Value]),'Table (41)'[Supplier]=_supplier)
ValtteriN_4-1722596426510.png

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Apologies if a simple question but how to you modify the filter context?

In the example I provided:

Measure 32 =
var _supplier = MAX('Table (42)'[Supplier]RETURN
CALCULATE(SUM('Table (41)'[Value]),'Table (41)'[Supplier]=_supplier)

Here we take the supplier information from one table and use it to calculate the corresponding value from the other.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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