Forum Discussion
Filter Table Based on TOP N and Bottom N
I have 3 tables : Pseudo Retailer Table Bottom Sales Table Bottom N Table I want the Bottom Sales Table to be filter by table Pseudo Retailer on retailer name. Currently I have cre...
amitchandak
Super User
Super Userpravkan , You can use
CALCULATE([Total Sales],TOPN([SelectedBottomNValue_RetailerBottom],allselected('BOTTOM N RETAILER TABLE'[RETAILER NAME], 'BOTTOM N RETAILER TABLE'[product subcategory NAME]),[Total Sales],DESC),VALUES('BOTTOM N RETAILER TABLE'[BOTTOM N RETAILER]))
To filter we need use summarize of values
Sumx(filter(addcolumns(Summarize('BOTTOM N RETAILER TABLE'
'BOTTOM N RETAILER TABLE'[RETAILER NAME], 'BOTTOM N RETAILER TABLE'[product subcategory NAME]), "_1", [Rank], "_2", [Total Sales] ) , [_1] <= [SelectedBottomNValue_RetailerBottom]) , [_2])
This is what I want to achieve with Power BI
I don't know if this possible in dax.
Normally I have all these data stored in a table called V_BOTTOM_SALES