Sum causing duplicate values

[JMccoy92]

I have ran into an issue with my Data Model within Power Bi that I cannot resolve or make sense of. 

I have two separate fact tables one is called Proposals and the other is called Opportunties. They both use a common dimension called DimOpportunties. They are on different grains as in there can be multiple proposals per each opportunity. 

The visual I am using with each of these is a simple table. in the table we pull in details from the DimOpportunities table that will tie both of these fact tables together. From the Proposal table I am using a simple count of the ProposalID- DistinctCount(ProposalID). The opportunities table I am doing a sum of a column- Sum(ColumnName). For some reason when I drag this created measure to the table it causes duplicates, giving the sum of each opportunity for each proposal. However, whenever I drag over just the column that was used for the measure, which is then turns into a sum by the system, this does not create a duplicate. What is wrong with my model or measure to get this reaction. 

[v-luwang-msft]

Hi @JMccoy92 ,

Could you pls share your pbix file and expected output.Remember to remove confidential data.

Best Refards

Lucien

[amitchandak]

@JMccoy92 , Need to check with Data. Unless there is a not-summarised column present in visual from these two fact, it should not happen

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.