Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

TopN + Others - Circular reference

Hi all, I've been struggling with a formula for a few days now so I'm reaching out for help.  I have read multiple articles and posts but still can't figure out what's causing the circular reference...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak   the statements works perfectly on your data!  This tells me the error has somthing to do with my data.  I'll keep digging to try and find out why. 

 

Items TopN+Others = 
VAR RankItemSales = RANKX(ALLSELECTED('Item'),CALCULATE(SUM('Sales'[Net Sales])),,DESC)
return
if (RankItemSales<=10,('Item'[Brand]),"Others")

 

amitchandak's avatar
amitchandak
Super User
6 years ago

You are creating a column in your data and I think we were trying for the measure. I created as measure and it worked

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Create a measure or In case you want a column. Create two. Also, in case of column rank will not take the Aggregated column. Also no need of first non blank