Count returns wrong result?

[Paint_bynumbers]

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?

[Paint_bynumbers]

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?

[Ttaylor9870]

What does 50|13554 mean? Is it suppose to be a text column but is formatted as numerical?

[Paint_bynumbers]

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