Displaying top value

[Anonymous]

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

[Ashish_Mathur]

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]

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 %)

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.