Forum Discussion
TOPN dynamic
I am using the formula to create a table
TabelaRank =CALCULATETABLE(VALUES(Sales[Pagamento]);TOPN (1; ALLSELECTED(Sales[Pagamento]); [Asset Rank]; ASC ))
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])
but I want to make the 'n_value' parameter dynamic, but it does not. Only works with typed values.
Someone can help ...
thank you.
7 Replies
Hi,
create a parameter and give name as Top N by default select as slicer to page.
Create a Measure to calculate Dynamic Top N on any dimension like, Top N Customers, Top N City etc.
Before this we should create measure from data table here I am using orders table and creating measure for sale as below,
Sales Amount = SUM(Orders[Sales])
Create Top N Customers Measure as below under data table which is orders for now,
TopN Customers =
VAR SelectedTop = SELECTEDVALUE('Top N'[Top N])
RETURN
SWITCH(TRUE(),
SelectedTop = 0, [Sales Amount],
RANKX (
ALLSELECTED( Orders[Customer Name] ),
[Sales Amount],,DESC
)
<= SelectedTop,
[Sales Amount]
)
Result:
Anonymous
is not it.
I need to create a table with the top 3 of a Rankx list.
it is not to be changing the amount of rankx.
Review the initial question.thank you;
Hi,
Write the RANKX function instead and filter the result of the RANKX function with a crtieria of say <=3.
Ashish_Mathur
thank you... but....the TOPN function in DAX the N_Value parameter does not work when the value comes from a measure, only accepts value typed.
I want to use a dynamic value for this parameter that comes from a SLICER.How to make it happen?
Hi,
The N value in the TOPN() function can be the result of a measure. Create a Table with 5 values (from 1 to 5). Name that as Rank_values. Create a slicer visual and drag the Values field from the Rank_values Table. Select anyone value there. Write this measure
Selected Top N = MIN(Rank_values[Value])
In your RANKX formula, the first inout should be [Selected Top N]
Hope this helps.
