Forum Discussion

drew61199's avatar
drew61199
Frequent Visitor
4 years ago

How to find MAX of RANK

I have a fairly complicated report in Excel that I'm migrating to Power BI. Here is the calculation breakdown (and if anyone has an easier way to calculate....I'm open to it): Contains over 10,000 ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

drew61199 , If I want to know max rank, I need a measure

 

maxx(values(Report[Location]), [rank_test_data_1])

drew61199's avatar
drew61199
Frequent Visitor
4 years ago

Thank you for the reply. The formula works great in a card, but when added to the matrix, it displays the rank for each individual location. Ultimately I need DIVIDE(100, FACTOR), so I would expect 100 / 479 = .209, but as you can see, the factor is unique for each location

 

 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi drew61199 ,

     

    Cay you try

    FACTOR_test1 = CALCULATE( MAXX(values(Report[Location]), [rank_test_data_1]), ALL(Report))

     

    If not work, please share your some sample data and expect result.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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