Forum Discussion
Solved
Top N Within Matrix Table
Hey Power BI Community, I have a question regarding potential augmentation and context-changing of Power BI Top N filter capabilities. I have a matrix table right now that deals with positions...
Hi fordmichael20,
Add a measure to your table with the following formula:
Rank_WITH_ALL = RANKX ( ALL ( Portfolio[Issuer] ), CALCULATE ( SUM ( Portfolio[Market Value] ) ) )Then use this column in your matrix, if you need to hide it just reduce the size of the column
The second image is with the column reduced.
Regards,
MFelix
Hi fordmichael20,
Add a measure to your table with the following formula:
Rank_WITH_ALL =
RANKX (
ALL ( Portfolio[Issuer] ),
CALCULATE ( SUM ( Portfolio[Market Value] ) )
)Then use this column in your matrix, if you need to hide it just reduce the size of the column
The second image is with the column reduced.
Regards,
MFelix
Hi! I am trying to do the same but adding a "Other" row in the matrix for those below to 21 (I am doing top 20) how can I do that?
where you able to do this? I am working on something similar group everything else in other category...
