topic Re: Ranking using partition from relationship in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ranking-using-partition-from-relationship/m-p/3350642#M125812 <P><EM><STRONG><A href="https://1drv.ms/u/s!AsDP3LYI8umspV-pdW6ebHxWbHQJ?e=BPvnNR" target="_blank" rel="noopener">RnkEvt.pbix</A></STRONG></EM></P><P>&nbsp;</P><P><img /></P> Wed, 26 Jul 2023 09:39:34 GMT ThxAlot 2023-07-26T09:39:34Z Ranking using partition from relationship https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ranking-using-partition-from-relationship/m-p/3348932#M125748 <P>I have a table of item details, and a table of events, which are either good or bad (1 or 0). There is a one-to-many relationship between 'Details'[Item ID] and&nbsp;'Events'[Item ID]</P><P>&nbsp;</P><P>I'm trying to write measures that will rank each Item ID by Sum(Good/Bad), partitioned by the Item Owner, and an overall ranking.</P><P>Any filters on the visual/page should affect the ranking.</P><P>&nbsp;</P><P>Details</P><TABLE border="1"><TBODY><TR><TD>Item ID</TD><TD>Owner</TD></TR><TR><TD><P>101</P></TD><TD>Dave</TD></TR><TR><TD>102</TD><TD>Jeff</TD></TR><TR><TD>103</TD><TD>Jeff</TD></TR><TR><TD>104</TD><TD>Jeff</TD></TR><TR><TD>105</TD><TD>Dave</TD></TR><TR><TD>106</TD><TD>Jeff</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Events:</P><TABLE border="1"><TBODY><TR><TD>Item ID</TD><TD>Good/Bad</TD></TR><TR><TD>101</TD><TD>1</TD></TR><TR><TD>101</TD><TD>0</TD></TR><TR><TD><P>101</P></TD><TD>1</TD></TR><TR><TD><P>101</P></TD><TD>0</TD></TR><TR><TD><P>102</P></TD><TD>1</TD></TR><TR><TD><P>102</P></TD><TD>1</TD></TR><TR><TD><P>103</P></TD><TD>0</TD></TR><TR><TD><P>103</P></TD><TD>0</TD></TR><TR><TD><P>103</P></TD><TD>0</TD></TR><TR><TD><P>103</P></TD><TD>0</TD></TR><TR><TD><P>104</P></TD><TD>1</TD></TR><TR><TD><P>104</P></TD><TD>0</TD></TR><TR><TD><P>104</P></TD><TD>0</TD></TR><TR><TD><P>104</P></TD><TD>0</TD></TR><TR><TD><P>105</P></TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Desired Result:</P><TABLE border="1"><TBODY><TR><TD>Item ID</TD><TD>Owner</TD><TD>Count</TD><TD>Good</TD><TD>Rank Overall</TD><TD>Rank by Owner</TD></TR><TR><TD><P>101</P></TD><TD>Dave</TD><TD>4</TD><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>102</TD><TD>Jeff</TD><TD>2</TD><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>103</TD><TD>Jeff</TD><TD>4</TD><TD>0</TD><TD>5</TD><TD>3</TD></TR><TR><TD>104</TD><TD>Jeff</TD><TD>4</TD><TD>1</TD><TD>3</TD><TD>2</TD></TR><TR><TD>105</TD><TD>Dave</TD><TD>1</TD><TD>1</TD><TD>3</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P> Tue, 25 Jul 2023 14:02:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ranking-using-partition-from-relationship/m-p/3348932#M125748 Anonymous 2023-07-25T14:02:05Z Re: Ranking using partition from relationship https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ranking-using-partition-from-relationship/m-p/3350642#M125812 <P><EM><STRONG><A href="https://1drv.ms/u/s!AsDP3LYI8umspV-pdW6ebHxWbHQJ?e=BPvnNR" target="_blank" rel="noopener">RnkEvt.pbix</A></STRONG></EM></P><P>&nbsp;</P><P><img /></P> Wed, 26 Jul 2023 09:39:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ranking-using-partition-from-relationship/m-p/3350642#M125812 ThxAlot 2023-07-26T09:39:34Z