All Except not working

[RanjanThammaiah]

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?

1.Top25 value = CALCULATE(

     [Revenue],

         TOPN(25,GROUPBY('Sheet1','Sheet1'[OpportunityID]),

        CALCULATE(

    [Revenue],

    ALLEXCEPT('Sheet1','Sheet1'[ReportingRegion]))))

Regards,

Ranjan

[lbendlin · Accepted solution]

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])