Forum Discussion

Vladas's avatar
Vladas
Frequent Visitor
8 years ago

How to Rank by created measure

Hi,

 

How I can create a Rank by created measure. 

Rank Measure = ([Total SUM Qty]*0,7)*(MeasuresDiff[Diff CP - PD]*1,7)  .   

Now I want to create Rank by values. How can i do that? 

 

 

Need Help

4 Replies

    • Vladas's avatar
      Vladas
      Frequent Visitor
      8 years ago

      I tried to create calc colum, not measure = RANKX(ALLSELECTED('Item'[ItemId]);[Rating]) but all rows is blank in this column. 

       

      Rating is my calculation = CALCULATE(SUMX(SalesInvoice;SalesInvoice[InvoiceQty]*0,7)*[Diff CP - PD]*1,7)

      • popov's avatar
        popov
        Icon for Resolver III rankResolver III
        8 years ago

        Hello, Vladas
        Formula of Rank measure looks correct. Wich column do you use in matrix? Item[ItemId] or SalesInvoice[ItemId]?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    First, your naming is very confusing because what you created is a Measure that creates some vvalue. It is not a Rank. If you want to Rank that value I think you need to make that value a column and not a Measure. I may be incorrect in that.