Forum Discussion

vijay_27's avatar
vijay_27
Helper I
4 years ago
Solved

Correct Rank in Matrix

Hi    I have one table, consist of country , model and quantity  column,   When i create table view,  country, model, quantity it show correct rank,    But when i use table view it show correct ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    vijay_27 , Try isinscope

     

    Measure = if(isinscope('Table'[Model]), RANKX(ALL('Table'),CALCULATE(SUM('Table'[Quantity]),ALLEXCEPT('Table','Table'[country],'Table'[Model])),,DESC,Dense),[Measure 2])

amitchandak's avatar
amitchandak
Super User
4 years ago

vijay_27 , Try isinscope

 

Measure = if(isinscope('Table'[Model]), RANKX(ALL('Table'),CALCULATE(SUM('Table'[Quantity]),ALLEXCEPT('Table','Table'[country],'Table'[Model])),,DESC,Dense),[Measure 2])