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_exp...
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.
Hi, Ashish_Mathur
Help me....
I need to paint a chart only with the items selected in the RANK.
For this I put together a list and if it is in the list it paints the chart.
https://1drv.ms/u/s!AjVxNwZurzV3g3tOY08NA7cMl7yC
Tks
Hi,
I cannot understand the language there. Also, there are so many tables there that i do not know which one has the problem.