Forum Discussion

austin15g's avatar
austin15g
Regular Visitor
2 years ago
Solved

Help with RANK (with COUNTROWS modifier)

Hi all, I have a Power BI visual for audit executive that is meant to count all of the high-level categories that are mentioned in his conversations with other executives in the business. Taking it ...
  • austin15g's avatar
    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.