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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
BImaster159
Frequent Visitor

Please help me with setting up relationships

BImaster159_0-1712221593432.png

Hello, please look at the 3 tables with data I have. Going from left. Table 1 contains the budget. Table 2 "borrows" from the budget for each role (example: Manager borrowing 1000 dollars, Gardener borrowing 500 dollars) and Table 3 on the right is the real spent money. You borrow money then spend it and if you have some money left from the "borrowed" money you put it back in the first table. The 1 and 2 table are joined via Contract number and 2 3 via Order No.

I have a drillthrough going from Table 1 to Table 2. I put a matrix visualisation that shows Roles and Table 2 borrowed money  and Table 3 Spent money. Unfortunately Roles in Table 2 and 3 arent connected so it always shows the money from one side only. See screenshot below.

BImaster159_1-1712222355252.png

See the info from Table 2 Roles and Borrowed money shows right but Active projects price from Table 3 just sums up into one line and leaves all other lines empty. I think the problem is im using as rows in matrix the roles from Table 2 and they arent connected but I have no idea how to do it better. Please give me some advice. Is there a way to use Dax for this?

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@BImaster159 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi. I tried to draw the three tables and the expected output. I realised I might be able to do two different matrices each with Role and Money from both Tables 2 and 3 instead of putting it all in one matrix but I still dont know why its not working.

pbihelp.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors