Forum Discussion

reddy421's avatar
reddy421
Helper I
2 years ago

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

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.

 

Need Help

5 Replies

  • jgeddes's avatar
    jgeddes
    Super User
    2 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

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

    • reddy421's avatar
      reddy421
      Helper I
      2 years ago

      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's avatar
        Ashish_Mathur
        Super User
        2 years ago

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