Forum Discussion

ViralPatel212's avatar
ViralPatel212
Resolver I
2 years ago
Solved

Summary Table visual

Hello Team,   This may be hard to explain but here goes!  I am trying to create a table visual where it summarises the ranking of our dealers barclays based off our data points "Clients" The rank...
Need Help
Show and Tell
Tutorial Requests
  • ViralPatel212's avatar
    ViralPatel212
    2 years ago

    I have resolved this issue. 

     

    created a measure for barclays

    Measure: 
var _rank = RANKX(ALL('Dealer Ranking'[Counter Party]),[Ranking Size (Vol)],,DESC)
VAR _tab =
    FILTER (
        ADDCOLUMNS (
            ALL( 'Dealer Ranking'[Counter Party] ),
            "@rank", [Dealer Ranking Number 2 test]
        ),
        [Counter Party] = "Barclays"
    )
VAR _rankbarclays =
   CALCULATE( MAXX ( _tab, [@rank] ), REMOVEFILTERS('Dealer Ranking'[Glimpse_buy_side]))


RETURN

_rankbarclays