cancel
Showing results for
Did you mean:
Frequent Visitor

## Top N Power bi

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])
1 ACCEPTED SOLUTION
Super User

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

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines
Super User

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

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors