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.
