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 rank at drill level from country to model,  but when it show agrregate quantity  af country  level does not show correct  result. How i can correct rank at country please see the screenshot  attached and below two measure i'm using:

Measure = if(HASONEVALUE('Table'[Model]), RANKX(ALL('Table'),CALCULATE(SUM('Table'[Quantity]),ALLEXCEPT('Table','Table'[country],'Table'[Model])),,DESC,Dense),[Measure 2])
Measure 2 = RANKX(all('Table'),CALCULATE(sum('Table'[Quantity]),ALLEXCEPT('Table','Table'[country])),,DESC,Dense)
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])

1 Reply

  • 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])