Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Icon for Helper V rankHelper V
3 years ago
Solved

All Except not working

Hi All,   i wanted to change the top 25 value only for the Reporting Region filters. I have come up with the below DAX but it doesn't work.   May I know if anyone has any suggestions for this?  ...
Need Help
Show and Tell
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    3 years ago

    Something like

     

    Top25 = 
    var a = calculatetable(summarize('Sheet1',[OpportunityID],"sm",[Revenue]),ALLEXCEPT('Sheet1','Sheet1'[ReportingRegion]))
    var b = TOPN(25,a,[sm])
    return SUMX(b,[sm])

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Something like

 

Top25 = 
var a = calculatetable(summarize('Sheet1',[OpportunityID],"sm",[Revenue]),ALLEXCEPT('Sheet1','Sheet1'[ReportingRegion]))
var b = TOPN(25,a,[sm])
return SUMX(b,[sm])