DAX formula to sum

[nburaq]

Hi,
I have a data table like this

Mat No​	Qty
90552​	1
90552​	1
90563​	1
90563​	1
90563​	1
90563​	1
90563​	1
90563​	1
90563​	1
90564​	1

I would like to create a measure that will calculate sum of material like this:


90552 : 2
90563:7
90564:1

Later I will use this measure in my pivot table.

Thanks for your help

 

[Mark Prillman]

Hello, a simple measure with `sum` would solve your case:

My sum measure :=SUM(Table[Qty])