Ranking a dimension table with data of multiple hospitals using measure

[vensali]

Hi 

I have a  Speciality dimension table with specialities of multiple hospitals. I also have fact table with outpatient count from multiple hospitals. I need to rank  the speciality hospitalwise base on the respective hospital outpatient counts using measure

I request specialist's help to resolve the said issue.

Regads

Venkat

[Anonymous]

You can try something like 
Hospital Rank =
RANKX( ALL('Speciality dimension table', SUM( 'fact table'[outpatient count]))

[amitchandak]

@vensali , Try a measure like

Rankx(filter(summarize(allselected(Fact), fact[hospital],[Speciality]), [hospital] =max([hospital])), [outpatient counts measure],,desc,dense)

[tamerj1]

Hi @vensali 
Please send sample data with a screenshot of the data model relationships if any.