Count number of rows where the same ids

[Anonymous]

Hi, 

I hope you can help me. I am quite new in powerbi. 

I have a table where ids reoccure, and I want to count total number of rows. I have tried countrows however it only counts the same id once... Is this possible to bypass? 

Best regards 🙂

[tamdo95]

Hello,
In this case, I think you can use the COUNTROWS function. I hope this will help.

[Anonymous]

Hi Tamdo, 

I tried that but it returns the same number 

[tamdo95]

It depends on which visual you are using as well. Could you be more specific?

[Anonymous]

Hi again, i solved the problem. Thank you so much for your time!

[PiEye]

Which function are you using? Count() should return 10, but there is also a function called DISTINCTCOUNT() which will return the smaller number.

Also is your measure in the same table as where the ID is residing?

[Anonymous]

I am using count and it returns the smaller number, and i am doing it in another column 

[PiEye]

Is it the same table? What does your data model look like?

[Anonymous]

Yes it is the same table, i tried adding a new column 

[PiEye]

Do you have more information you can give us? I'm trying to recreate the issue, but can only make it happen if  the ID field is in a different table to the one with the measure

[Anonymous]

Hi again, i solved the problem. Thank you so much for your time!

[PiEye]

That's great Jarken - what was the issue?

Pi

[Anonymous · Accepted solution]

It was a wrong relation between two tables. Ups! 

[PiEye]

Good to know!

[PiEye]

Hi Jarken, can you elaborate?

Your  data looks something like this:

ID

1

1

1

2

2

3

4

5

5

6

You want a total count of 10, but it is showing 6?

Pi

[Anonymous]

Hi, 

Yes exactly, thank you for specifying! 😊