Measures from two sources will not display together.

[Anonymous]

I've got two sources of data. when combining the result of their measure, the excel data drops off the visualization.

Does anyone know why that is?

Example:

1st source is from Dynamics Business Central

Dynamics = sum(sales[total])  (100.00)

2nd source is from Excel

Excel = sum(sales[total])  (100.00)

Result = [Dynamics] + [Excel]   

The result should be 200.00, but the visualization only shows the $100.00 from the Dynamics side.

[vivran22]

Hello @Anonymous ,

Are these two tables related?

Cheers!
Vivek

https://www.vivran.in/
Connect on LinkedIn

[Anonymous]

They're connected to the dates table, and they have an indirect relationship through the value entries table.

Shared Table:

Dynamics 'OpensalesOrders'[orderdate]--> Dates[dates] < --Excel'PostingDate'[Date]

Indirect:

Dynamics: 'OpenSalesOrders'[Salespeople]   <--   'Salespeople'[Salespeople] --> 'Value Entries'[DocNO] <--   'GL'[DocNO] --> 'Excel'[DocNO]

I noticed that one measure shows up like this in the formal bar [Total] and another one shows up like this 'Excel'[Total]

e.g. Combined total = [total] + 'Excel'[total]

All my other measures show:     Combined total = [total] + [total]  and they're all from the same data source (Dynamics) the only foreign table is the Excel file.

[v-easonf-msft]

Hi, @Anonymous 

Not very clear. Can you click here to share your  model  view?

In fact , sample data/pbix file  will make it easier for us to understand and  solve your problem.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi Guys!

Thanks for the help with this. I've created this sample PBIX file for you guys to tinker with.

https://drive.google.com/open?id=1c9m-x6BIdqXHZOsnwYdjWR51YKwG1P-a

[parry2k]

@Anonymous how you are visualizing the data, if you are visualizing on date dimension then it should you correctly. Can you share sample data along with the relationship diagram and also how you are visualizing the data. There are many factors why it is not working or giving weird results.