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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors