topic Re: Count number of rows where the same ids in DAX Commands and Tips

Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 09:34:32 GMT

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 🙂

Re: Count number of rows where the same ids

PiEye — Tue, 15 Mar 2022 09:50:50 GMT

Hi Jarken, can you elaborate?

Your data looks something like this:

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

Re: Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 09:52:35 GMT

Hi,

Yes exactly, thank you for specifying! 😊

Re: Count number of rows where the same ids

PiEye — Tue, 15 Mar 2022 10:02:22 GMT

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?

Re: Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 10:03:49 GMT

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

Re: Count number of rows where the same ids

PiEye — Tue, 15 Mar 2022 10:49:43 GMT

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

Re: Count number of rows where the same ids

tamdo95 — Tue, 15 Mar 2022 11:03:35 GMT

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

Re: Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 11:14:28 GMT

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

Re: Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 12:05:55 GMT

Hi Tamdo,

I tried that but it returns the same number

Re: Count number of rows where the same ids

PiEye — Tue, 15 Mar 2022 12:23:26 GMT

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

Re: Count number of rows where the same ids

tamdo95 — Tue, 15 Mar 2022 12:29:37 GMT

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

Re: Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 13:40:41 GMT

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

Re: Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 13:40:59 GMT

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

Re: Count number of rows where the same ids

PiEye — Tue, 15 Mar 2022 13:43:02 GMT

That's great Jarken - what was the issue?

Re: Count number of rows where the same ids

Anonymous — Tue, 15 Mar 2022 13:46:15 GMT

It was a wrong relation between two tables. Ups!

Re: Count number of rows where the same ids

PiEye — Fri, 18 Mar 2022 08:23:35 GMT

Good to know!