Help with a sum formula

[Anonymous]

Hi, am very new to DAX, but trying to learn fast.

I have a  situtation where I'm trying to count the number of one item that exists in another column...

basicall my columns look like this

Container    Item

Box1           pear

Box1           apple

Box1           peach

Box2           apple

Box2           banana

I'd like to show how many items are in each box in the following format,

Box1    3

Box2    2

seems easy, but I'm struggling to get the formula for some reason.

[BhaveshPatel · Accepted solution]

You do not need any formula as the PowerBI engine automatically counts the no. of products in the Second Column. Drag the column 1 first and then column 2 values to the table visual and right click the Column 2 and select Count.

You can also right click on any column in your table and create measure using the below formula:

CountofProducts:=COUNTA(TableName[ColumnName])

[Anonymous]

thanks, that pointed me in the right direction.  With my data I ended up using a counta as you suggested. Initially, I had my fields reversed I believe so was getting inaccurate info.