Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

RANKX function is not working

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

 


 

 

General Comment

1 Reply

  • isjoycewang's avatar
    isjoycewang
    Solution Supplier
    2 years ago

    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), "")