Forum Discussion
Solved
TOPN query
I created a table called SALES_MGR_NET_SALES to list the Sales Managers and their Sales with this DAX expression: SALES_MGR_NET_SALES = SUMMARIZE(DIM_CUST_REP_HIER,DIM_CUST_REP_HIER[Sales Mgr],"S...
- Hi there
The 3rd argument of TOPN is evaluated in row context of the table supplied in the 2nd argument.
Because of that, you need to wrap the 3rd argument in CALCULATE to turn the row context into a filter context, i.e. ensure the expression is evaluated in a filter context corresponding to each sales manager.
MAX or SUM would both work here and nice you already have distinct sales managers.
TOP_TEN_SALES =
TOPN (
10,
SUMMARIZE ( SALES_MGR_NET_SALES, SALES_MGR_NET_SALES[Sales Mgr] ),
CALCULATE ( MAX ( SALES_MGR_NET_SALES[Sales] ) )
)
Hi there
The 3rd argument of TOPN is evaluated in row context of the table supplied in the 2nd argument.
Because of that, you need to wrap the 3rd argument in CALCULATE to turn the row context into a filter context, i.e. ensure the expression is evaluated in a filter context corresponding to each sales manager.
MAX or SUM would both work here and nice you already have distinct sales managers.
TOP_TEN_SALES =
TOPN (
10,
SUMMARIZE ( SALES_MGR_NET_SALES, SALES_MGR_NET_SALES[Sales Mgr] ),
CALCULATE ( MAX ( SALES_MGR_NET_SALES[Sales] ) )
)
The 3rd argument of TOPN is evaluated in row context of the table supplied in the 2nd argument.
Because of that, you need to wrap the 3rd argument in CALCULATE to turn the row context into a filter context, i.e. ensure the expression is evaluated in a filter context corresponding to each sales manager.
MAX or SUM would both work here and nice you already have distinct sales managers.
TOP_TEN_SALES =
TOPN (
10,
SUMMARIZE ( SALES_MGR_NET_SALES, SALES_MGR_NET_SALES[Sales Mgr] ),
CALCULATE ( MAX ( SALES_MGR_NET_SALES[Sales] ) )
)
That worked.
Thanks!