Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Displaying top value

Hi,

 

I have the following visualization in Power BI,

This table should display high performing office,

the performance is based on highest loan conversion from top 3 loan funded column

ie, the table should display Palmetto family dental.

 

Note: all the columns in the table except office name are calculated measures.

 

Please help me with how to approach this problem

Ashish_Mathur 

 

Thanks,

Dharanisree

Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    I do not understand your end result.  The highest loan conversion % is not 87.5%, it is 100%.  Why should the answer be Palmetto family dental?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      We should first rank based on loan funded(top 3)

      that gives, 

      1. west 10th dental group

      2. palmetto family dental

      3. Dunson dental design

       

      Within this three, we have to find the highest loan conversion,

      which is palmetto family dental (87.5 %)