Forum Discussion
avendanof
5 years agoHelper I
Topn function using a Parameter
After having read this post https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415 I was wondering why this is not working. I´ve first made a p...
- Anonymous5 years ago
// Careful here: this returns a table // so it can't be a measure!!! Measures // never return tables, only scalar // values. [5 mejores productos] = var vProdCount = SELECTEDVALUE( 'Top N'[Top N] ) var vResult = TOPN( vProdCount, ADDCOLUMNS( DimProducto[EnglishProductName], "@Suma", CALCULATE( FactVentas[Ventas] ) ), [@Suma] ) RETURN vResultYou can try the above... but this is not a measure. The code returns a table (as does yours), so I'm not sure what you're trying to achieve with this. If no selection has been made in the Top N table, then this will return nothing. And for such a selection to occur, the parameter table must be put in a visual. But the code above, as I said, returns a table, so you'll not be able to use it, even if there's been a selection made in the slicer.
avendanof
5 years agoHelper I
Thanks a lot, actually, yes, a table is what I expect. Ehat I don´t actually understand is why I need to pass throgh a variable instead of using the selectedvalue in the topn directly.
Regards!!! and have a fine day.