Forum Discussion
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? ...
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])
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])