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 ...
Need Help
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.