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?
1.Top25 value = CALCULATE(
[Revenue],
TOPN(25,GROUPBY('Sheet1','Sheet1'[OpportunityID]),
CALCULATE(
[Revenue],
ALLEXCEPT('Sheet1','Sheet1'[ReportingRegion]))))
Regards,
Ranjan
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])
1 Reply
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])