Excluding filter selection not working with AGGR

[ChannaK]

Hi I have two expressions first case

i need ignore CalendarYearQuarter selection as filter below expression works fine

sum({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'},TableName ={'Stage1Date'}, Mapped={'AE OB'},[Type.Opportunity] ={'New business'},[POC_Opportunity.Opportunity]={'0'},[WOCRecord.Opportunity]={'0'}>} ImpliedRevenueP1)

in below case i am calculating % in denominator i need to use AGGR function this case it is not working any help?

sum({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'},TableName ={'Stage1Date'}, Mapped={'AE OB'},[Type.Opportunity] ={'New business'},[POC_Opportunity.Opportunity]={'0'},[WOCRecord.Opportunity]={'0'}>} ImpliedRevenueP1)
/
sum(aggr(max({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'}>} AE_TARGET),InitialQBRTeam_rep,InitialCreatedByUserName_Rep,StartDateQuarterName))

[rubenmarin · Accepted solution]

Hi, you also need to use set analysis in the external sum:

sum({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'}>} aggr(max({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'}>} AE_TARGET),InitialQBRTeam_rep,InitialCreatedByUserName_Rep,StartDateQuarterName))