How to get Table for year wise distinct count of quantity.

[Anonymous]

Hi Team,

I quite newbie to Power BI DAX

Apology of this is silly question but I am not able to get it.

I have a table: has data for suppose 2010 to 2015 (refer table below). I want to get the output as a

Table where I will have 2 columns YEAR and DISTINCT COUNT OF QUANTITY YEAR WISE

note: I want a table. I am able to create measure for getting distinctcount of quantity.

Distinctcount = DISTINCTCOUNT(Table1[Quantity])

but this is measure where i need to see through table visual. I want table in data view.

How can I create table to get distinct count of quantity year wise.

below is a input table: 

Year           Month     Day    Quantity

2010	1	1	184
2010	2	22	130
2010	3	21	113
2010	4	13	122
2010	5	30	145
2010	6	12	157
2010	7	17	100

output table should be:

Year	Quantity
2010	7
2011	9
2012	10
2013	20
2014	56
2015	78

[amitchandak · Accepted solution]

@Anonymous , New table like 

New table =

summarize(Table, Table[Year], "Qty", DISTINCTCOUNT(Table1[Quantity]))

[Anonymous]

Thanks alot its working.