Value changes when I select the dimension

[StacyCui]

Hi, I have aggregate two dimensions. And then When I don't select any thing. For 'RNE' is 41150. But When I click it. It changes into 939751. It's all based on the same condition. 

Here is the dimension:

=if(WildMatch(DE,'FA DE Enabled' ,'FA DE Design' ,'FA DE' ,'FA DE Edge&AI' ,'FA DE Design Service Enable' ,'FA Digital Solution')>0 ,'FA Digital Solution' ,DE)

Here is the Measure:

=SUM ( AGGR(

if(wildmatch(DE,'FA DE Enabled','FA DE Design','FA DE','FA DE Edge&AI','FA DE Design Service Enable','FA Digital Solution')>0
,Sum({<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Enabled"}>}FA_DE_Enable_OR)
+Sum( {<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Design"}>}[OR Value RMB])
+Sum({<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Design Service Enable"}>}FA_DE_DesignServiceEnable_OR)
+Sum({<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Edge&AI"}>}[OR Value RMB])
,Sum({<[FiscalYear]={$(v_CurrentYear)}>}[OR Value RMB])
) ,DE))

[PrashantSangle]

Hello,

It is because your aggr(), in your expression you are doing aggregation on only on column, but you are expecting it to work for all dimension.

you have to include all dimension in your aggr()

Regards,

Prashant Sangle

[StacyCui]

Hi, Thank for your reply. I really appreciated. I have changed the expression as follow. But, it shows 0

=SUM ( AGGR(

if(wildmatch(DE,'FA DE Enabled','FA DE Design','FA DE','FA DE Edge&AI','FA DE Design Service Enable','FA Digital Solution')>0
,Sum({<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Enabled"}>}FA_DE_Enable_OR)
+Sum( {<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Design"}>}[OR Value RMB])
+Sum({<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Design Service Enable"}>}FA_DE_DesignServiceEnable_OR)
+Sum({<[FiscalYear]={$(v_CurrentYear)},DE={"FA DE Edge&AI"}>}[OR Value RMB])
,Sum({<[FiscalYear]={$(v_CurrentYear)}>}[OR Value RMB])
)
,if(WildMatch(DE,'FA DE Enabled' ,'FA DE Design' ,'FA DE' ,'FA DE Edge&AI' ,'FA DE Design Service Enable' ,'FA Digital Solution'),'FA Digital Solution' ,DE)))