topic Re: Ranking a dimension table with data of multiple hospitals using measure in DAX Commands and Tips

Ranking a dimension table with data of multiple hospitals using measure

vensali — Thu, 10 Feb 2022 09:56:59 GMT

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

Re: Ranking a dimension table with data of multiple hospitals using measure

tamerj1 — Thu, 10 Feb 2022 11:47:33 GMT

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

Re: Ranking a dimension table with data of multiple hospitals using measure

amitchandak — Thu, 10 Feb 2022 11:55:15 GMT

vensali , Try a measure like

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

Re: Ranking a dimension table with data of multiple hospitals using measure

Anonymous — Thu, 10 Feb 2022 11:59:10 GMT

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