Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
Solved! Go to Solution.
It was a wrong relation between two tables. Ups!
Hello,
In this case, I think you can use the COUNTROWS function. I hope this will help.
Hi Tamdo,
I tried that but it returns the same number
It depends on which visual you are using as well. Could you be more specific?
Hi again, i solved the problem. Thank you so much for your time!
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?
I am using count and it returns the smaller number, and i am doing it in another column
Is it the same table? What does your data model look like?
Yes it is the same table, i tried adding a new column
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
Hi again, i solved the problem. Thank you so much for your time!
That's great Jarken - what was the issue?
Pi
It was a wrong relation between two tables. Ups!
Good to know!
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
Hi,
Yes exactly, thank you for specifying! 😊
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |