Forum Discussion

LUCASM's avatar
LUCASM
Icon for Helper IV rankHelper IV
4 years ago
Solved

Adding a TOPN Filter to a Measure

I am rewriting this as I still dont have an answer and my original post has dried up. I have the following cards  The top 50 is 297,219 / 436,661 = 68.1% of the Total for 1 week However If I...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Here is a more accurate representation that also works on line level.

     

    SU Top10 = 
var mw = MAXX(all(Weekly),[YYYYWW])
var ft = filter(all(Weekly),[YYYYWW]=mw)
var ms = SUMMARIZE(ft,[Short Name] ,"s",sum([Sales Units]))
var tt = SELECTCOLUMNS(TOPN(10,ms,[s]),"Widget",[Short Name])
var mc = SUMMARIZE(Weekly,[Short Name] ,"s",sum([Sales Units]))
var mf = filter(mc,[Short Name] in tt)
return sumx(mf,[s])
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Here is a more accurate representation that also works on line level.

 

SU Top10 = 
var mw = MAXX(all(Weekly),[YYYYWW])
var ft = filter(all(Weekly),[YYYYWW]=mw)
var ms = SUMMARIZE(ft,[Short Name] ,"s",sum([Sales Units]))
var tt = SELECTCOLUMNS(TOPN(10,ms,[s]),"Widget",[Short Name])
var mc = SUMMARIZE(Weekly,[Short Name] ,"s",sum([Sales Units]))
var mf = filter(mc,[Short Name] in tt)
return sumx(mf,[s])
LUCASM's avatar
LUCASM
Icon for Helper IV rankHelper IV
4 years ago

What are you using "Widget" for in 

var tt = SELECTCOLUMNS(TOPN(10,ms,[s]),"Widget",[Short Name])