Forum Discussion
How to exclude Items from nested DAX using multiple formulas?
Anonymous , Try like
Best in Class Top 5 Average = CALCULATE(AVERAGEX(TOPN(5, SUMMARIZE(filter(all(Company),Company[Segment]="SMB" && not( [Company Name] in {"Company A", "Company B", "Company C", "Company D"})),[Company Name],"NROI", [Item Value]),[Item Value],DESC),[Item Value]),all('Global Region'))
If you want to exclude on measure and not in other. create those two separately and then use in this formula
Anonymous , Try like
Best in Class Top 5 Average = CALCULATE(AVERAGEX(TOPN(5, SUMMARIZE(filter(all(Company),Company[Segment]="SMB" && not( [Company Name] in {"Company A", "Company B", "Company C", "Company D"})),[Company Name],"NROI", [Item Value]),[Item Value],DESC),[Item Value]),all('Global Region'))
If you want to exclude on measure and not in other. create those two separately and then use in this formula
amitchandak Thank you!