Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

var/return

 

i am trying to put in these two measures

 

now_termination = RANKX(ALL( Matrix_tab[NC]), [Termination Rank_1])
Termination Rank_1 = CALCULATE(SUMX(Matrix_tab,Matrix_tab[Termination_1]),FILTER(Matrix_tab,Matrix_tab[Void month]))

 

 into 

 

measure =
VAR term1 = CALCULATE(SUMX(Matrix_tab,Matrix_tab[Termination_1]),FILTER(Matrix_tab,Matrix_tab[Void month]))
return
RANKX(ALL( Matrix_tab[NC]), term1)


 

  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I am not sure your data structure, you could refer to my sample for details. If this is not what you want, please correct me and inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    what is the question?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am trying to use the rankx function
      when i try
       RANKX(   ALL(Table[column1]),
                                        CALCULATE(SUMX(Table, Table[column2]),FILTER(Table,Table[month]))

       it gives the contant ranking of 1
      except i use 2 different measures

       

      Measure2 = RANKX(ALL( table[column1]), Measure1)
      measure1= CALCULATE(SUMX(Table ,Table[Column2),FILTER(Table,Table[month]))

       

      so 


      i was wonering if its is possible to  infuse