cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pbra
Frequent Visitor

DAX and reltionships

Hello folks,

 

To connect an parameterpage, I´ve made an relationship between a parameterpage. On the parameterpage, there´s is the basic stuff like brand, edition, colour, amount of boxes on pallet, identificationkey. On the other page (daily production), I´ve got real-time data. I´ve connected the twpo pages by identification key. This is shown in text. For example:

 

On Nov 1, 2021, the daily based production is as follows:

Identification keyAmount
BMW.X5.V2800
BMW.X6.V8240

Mercedes.X3.V2

310
Audi.A5.V8125
Porsche.992.V6

35

 

Most of the identification keys (for example Audi.A3.V2) have no values, because they simply have no values for that specific day. I use the data from the parameter sheet for the identification key. The values of the numbers are coming from the sheet of the daily production.

 

Now the problem: I get different numbers if I use the relationship between the two datatables. When I only use teh Daily production, I´ve got for example an amount of 45 Porsche.992.V6. When I turn on the relationship between the two tables, I´ve got an amount of 35 Porsche.992.V6. I´m curious who could help me!

 

Cheers!

 

2 REPLIES 2
maurizio75
Frequent Visitor

There is no much information available but I would check two things: the relationship one to multi that the one is on the table with your unique identifier. Second you can get funny numbers and answer if your identification key is from the daily production table 

Greg_Deckler
Super User
Super User

@Pbra 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.


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors