Forum Discussion
Post ProdigyCalculate Total Pay by Sales Rep
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
Super UserHi 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
