Forum Discussion

Walgama's avatar
Walgama
New Member
3 years ago

Lab Practices (Lab 06A - Using DAX in Power BI Desktop Part 1)

Hi All,

Please help me to overcome this ambiguity when viewing the total sales by using two queries, the Salesperson and the salesperson (performance) query.  In the performance report, the total sales are wrong against the actual sales done by each person. Please refer to the attached screenshot. 

Please help me to understand this situation

Thanks 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Walgama ,

    There is no screenshot in your post, could you please share it again? And in order to make troubleshooting ang give you a suitable solution, could you please provide more raw data in  the Salesperson and the salesperson (performance) query (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards