Forum Discussion
Count returns wrong result?
I load only one csv File with 479388 rows in Power BI.
If I do a “COUNTROWS(mytable)” I get 479388.
If I do “COUNT(mytable[%Key])” on a Key Value I get 229812854544.
The values in %Key are like the “50|13554”.
What is creating this number 229812854544? I excepting the number should not be higher then 479388.
Can somebody explain what I do wrong? What is Power BI counting?
3 Replies
What does 50|13554 mean? Is it suppose to be a text column but is formatted as numerical?
“50|13554” means nothing it’s only a Key like Order number. It’s is formatted as text in the data modell.
But what I want to know is how many rows are in the table with a %key and how many are unique.
I think I found my mistake, I created a new column instead of a new measure.
But I’m still confused what this new column counts?
