Issue with Data Duplication when adding SalesPerTransaction Measure in Power BI Report

[reddy421]

Hello, I have a concern regarding the duplication of data when I add my SalesPerTransaction (SPT) Measure to my Power BI report. Below is the structure of my model.

The data appears correctly for one check (which is satisfactory).

 

 

However, when I include the SPT measure, the data duplicates as shown below. Here's the formula I'm using for SPT:

SPT = SUM(IG_Check[GrossRevenue]) / COUNT(IG_Check[CheckNumber])

 

I would appreciate any assistance with resolving this issue. Thank you.

[Ashish_Mathur]

Hi,

I cannot understand anything from those tiny images.  Share some data to work with, explain the question and show the expected result.

[reddy421]

@Ashish_Mathur ....
Sorry for the tiny pics.

I was expecting only one row since for this.

This is one check that is one item being purchased.

 

But as soon as I drop the measure(SPT), I get the data like below.

 

Hope this pics are better than before.

[Ashish_Mathur]

Cannot work with pics.  I will need a file.  Show the expected result there clearly.

[jgeddes]

If you change the relationship between IG_CheckItem and IG_MenuItem to bi-directional do you get your desired result?

[reddy421]

@jgeddes ... No it did not work.