cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Urielpc
Frequent Visitor

CUNTROWS measure shows only on blank row with total

Hello,

I have one customers table
and one Salespersons table

 

the relationship between those to are "Salesperson name"
my relationshipis active !!!

 

i tried to see hoe much customer to one Salesperson
but i just get one row with blank and total number of customers

 

any help please, thanks

1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

Can you remove sensitive data and share a pbix file. I suspect the sales person names aren't matching exactly.

 

A good place to start is running the clean and trim transforms on both columns in power query.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

2 REPLIES 2
Urielpc
Frequent Visitor

Hello and thank you,

My mistake,
I merged first name and last name in the wrong wa

 

thank you very mach.

bcdobbs
Super User
Super User

Can you remove sensitive data and share a pbix file. I suspect the sales person names aren't matching exactly.

 

A good place to start is running the clean and trim transforms on both columns in power query.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!