Forum Discussion
Advocate IITop 15 in a report
I use the Rank X measure for my products in the filter area of the visual (or whole page as needed). Then, when I add other values, there is nothing to break. I don't put the Rank X in the visual, I just use it as a filter for the page/report. In fact, I usually fill in all other information then apply it last to pull up my top 25.
Unreal, this worked =), thanks so much. Would you be able to explain why the calculate function was required? How is that different to just having SUM?
Community Championwithout CALCULATE the filter context for each row is always the same - all items have the same rank 1 this way
CALCULATE performs the context transition for each row of the table
Thanks Sean. So effectively, without CALCULATE the measure is looking at each row individually, and ranking it #1. Where calculate forces the measure to look at the whole data set?