How to calculate sum of a category ?

[selected_]

I have a column which look like this:

Category

new order

old order

cancelled order

pending

cancelled order

new order

new order

pending

new order

pending

What I want is that I want to make a measure total of each one in that category column.  

For example new order = 120

pending = 200

[amitchandak]

@selected_ , A measure like

Sumx(Table, Switch( True() , [Category] = "new order" ,120 , [Category]="pending ",200,0))

[selected_]

@amitchandak 

I don't have the values of each one in that category that's why I wanna calucate a measure count on how many "new order" or "pending" are in that category.

[amitchandak]

@selected_ ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[selected_]

@amitchandak

The column in my dataset look like this, new order and pending with more than one records

Category

new order

new order

new order

new order

new order

new order

pending order

pending order

pending order

What I for output it gonna count amount new order and pending in each column order in to a new table like this

Category	Total
new order	6
pending order	3

[v-lionel-msft · Accepted solution]

Hi @selected_ ,

Please create a measure like this.

Measure = COUNT(Sheet5[Category])

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.