Top N Power bi

insandur — Mon, 10 Oct 2022 11:17:35 GMT

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'

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])

Re: Top N Power bi

amitchandak — Mon, 10 Oct 2022 16:35:19 GMT

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]))