Forum Discussion
Post ProdigyCalculate Total Pay by Sales Rep
Hi BI Community Team,
I want to calculate the total pay out by sales rep and month but when apply the measure, I get the same result as the screenshot below.
Any suggestion/advise how to calculate it correctly?
Thanks and Regards,
Hi ADSL , when Power BI display the same value, row over row, its basically telling you that it doesnt know relationship between the tables being used in the visual. In your case, in the Employee table you have a lot of empty rows (picture below), which results in a many to many relationship with the Montly table. To correct this, remove empty rows -> make sure relationship is one (employee) to many (montly).
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
2 Replies
- goncalogeraldes
Super User
Hi ADSL , when Power BI display the same value, row over row, its basically telling you that it doesnt know relationship between the tables being used in the visual. In your case, in the Employee table you have a lot of empty rows (picture below), which results in a many to many relationship with the Montly table. To correct this, remove empty rows -> make sure relationship is one (employee) to many (montly).
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes- ADSL
