Forum Discussion

bptyates's avatar
bptyates
Frequent Visitor
4 years ago
Solved

Measure not working

Hi All,   So I have the following calcluation to rank items that are sold by the invoicved amount and it works fine.     Product Running Total = RANKX( ALL(Sheet1[Item]), [...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    bptyates , if you add any other column in visual, other than one you selected in rank, the rank will inside that one

     

    You are using 'Ames Sales'[Material] and you add 'Ames Sales'[Material ID] , then you rank will inside 'Ames Sales'[Material ID], all 1 . Only 1 material inside id


     

    there we add both column, in rank all . or use table

     

    example

     

    Sales Ranking = RANKX(
    AlL('Ames Sales'[Material], 'Ames Sales'[Material ID]),
    [Invoiced Sales],,
    DESC,
    Dense
    )

    or

    Sales Ranking = RANKX(
    AlL('Ames Sales'),
    [Invoiced Sales],,
    DESC,
    Dense
    )

     

     

    Also, check

     

    Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA

amitchandak's avatar
amitchandak
Super User
4 years ago

bptyates , if you add any other column in visual, other than one you selected in rank, the rank will inside that one

 

You are using 'Ames Sales'[Material] and you add 'Ames Sales'[Material ID] , then you rank will inside 'Ames Sales'[Material ID], all 1 . Only 1 material inside id


 

there we add both column, in rank all . or use table

 

example

 

Sales Ranking = RANKX(
AlL('Ames Sales'[Material], 'Ames Sales'[Material ID]),
[Invoiced Sales],,
DESC,
Dense
)

or

Sales Ranking = RANKX(
AlL('Ames Sales'),
[Invoiced Sales],,
DESC,
Dense
)

 

 

Also, check

 

Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA

  • bptyates's avatar
    bptyates
    Frequent Visitor
    4 years ago

    Sorry, im not sure I understand, I dont have  'Ames Sales'[Material ID] in my data. 

    • bptyates's avatar
      bptyates
      Frequent Visitor
      4 years ago

      But the second option worked - thank you.