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,
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?