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 th...
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.