Count number of values

[Anonymous]

Hi guys, 

i want to count the number of values i have in a table: 

What i want is this: 

ATM i have this measure but it does not work: 

Anybody any ideas? 

Appreciate!!

Thx

[amitchandak]

@Anonymous , You need to all except in the measure 

count = calculate(Table[Column1], allexcept(Table,allexcept(Table,Table[SKU]))

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

In case you need a new column

countx(filter(Table,table[SKU]=earlier(Table[SKU])),Table[Column1])

[harshnathani]

Hi @Anonymous ,

Measure = CALCULATE (COUNT ('Table' [SKU])))

and make sure valus are not Summarized.

Regards,

Harsh Nathani

[Greg_Deckler · Accepted solution]

Perhaps:

Measure =
  VAR __SKU = MAX('Table'[SKU])
RETURN
  COUNTROWS(FILTER(ALL('Table'),[SKU] = __SKU))

@Anonymous