Top N Power bi

[insandur]

I am Trying to get the "Code" which has maximum quntity or most Stock Qty in the table and should get filtered based Entity.

Table name : 'This month''s Stock Out'

Stock Qty	Month	Code	Supplier	Entity
2	10	BLR	AB	G2
2	10	APAG	BC	G1
2	10	PIO67	BC	G1
0	10			G2
1	10	TR28G	CZ	G1

i tried below code but dont get filtered on the Entity.

Stock Qty Code = TOPN(1,

CALCULATETABLE('This month''s Stock Out',

'This month''s Stock Out'[Month]=MONTH(TODAY()-1)),

'This month''s Stock Out'[Stock Qty])

[amitchandak · Accepted solution]

@insandur , First Create a measure with help from a separate month table joined with month of your table

this month = calculate(Sum(Table[Stock Qty]), filter(all(Month), Month[Month] = max(Month[Month] )) )

TOP1 Name= CALCULATE([this month], TOPN(2,ALLSELECTED('Table'[Code]), [this month ] ,DESC), values('Table'[Code]))