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!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors