Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ADSL
Post Prodigy
Post Prodigy

Calculate 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? 

 

 

2023-04-04_18-58-12.png

 

Thanks and Regards,

1 ACCEPTED SOLUTION
goncalogeraldes
Super User
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). 

 

goncalogeraldes_0-1680610113487.png

 

goncalogeraldes_1-1680610140174.png

 

 

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

View solution in original post

2 REPLIES 2
goncalogeraldes
Super User
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). 

 

goncalogeraldes_0-1680610113487.png

 

goncalogeraldes_1-1680610140174.png

 

 

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

Hi @goncalogeraldes ,

 

Thank you for your helpful feedback.

 

Best Regards,

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.