Forum Discussion

fordmichael20's avatar
fordmichael20
Frequent Visitor
9 years ago
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...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    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

MFelix's avatar
MFelix
Super User
9 years ago

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

fordmichael20's avatar
fordmichael20
Frequent Visitor
9 years ago

Hey,

 

This is great, thanks so much for your help.

 

Mike