RANKX function is not working

[Anonymous]

I have a simple table from Google Analytics that look at website pageviews for a online news site.

The table (Views) consist of the following columns:
"Category" "screenPageViews" "pageTitle" "date" and "FullURL"

I have this function that works perfectly:

RankCat =

VAR ViewRank = RANKX(ALL(Views[Category]), CALCULATE(SUM(Views[screenPageViews])),,DESC)

RETURN

ViewRank

However this function is not working correctly:

RankArt =

VAR ViewRank = RANKX(ALL(Views[pageTitle]), CALCULATE(SUM(Views[screenPageViews])),,DESC)

RETURN

ViewRank

[isjoycewang]

Hi @Anonymous,

I create some dummy data for demo: Exercise File

Please consider that there is also 'Category' column in your second table.

RankArt = 
IF( HASONEVALUE(Views[Category]),
RANKX( ALL(Views[pageTitle],Views[Category]),  CALCULATE(SUM(Views[screenPageViews])),,DESC), "")