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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.