Forum Discussion
Help with RANK (with COUNTROWS modifier)
- 2 years ago
For anyone in the future looking at this: I was able to finally get it by using the following RANK measure and setting up my table in the following way. In the table, I just added a column that contained a 1 in every row that was used in the SUM portion of my RANK measure. I opted to just use a calculated column in the table as opposed to going with a measure that counted the rows since I couldn't figure out how to make that work. As you'll see, I went through a few iterations of the calculated column: The first producing the sum of all Secondary Processes Mentioned in the table (will produce the same value for every line that has the same secondary process). The second being the sum of all Secondary Processes Mentioned for every Executive (Name). The last just being a 1 in every single row. I'm sure there's probably a more proper way of doing this, but this is how I achieved my desired result.
austin15g , The Ranking is based on the Number of Mentions, and You are using #Discussion in the visual, are they the same, if not, please add the Number of Mentions in the visual and check the ranking.
Also you can use allselected('Fact Management mentions'[Seconday Process Mensioned]) in place summarize