Merged dimension calculation problem

[ju_mia]

Hello I have a merged dimension called "Proj.code project" (2nd line of the table)

I want to add up each "Item Code Fact." (1st column left) f

or any project code I want to get the table found on the right.

However the second column from the left is a merged dimension and I think this is problematic in my formulas

[ju_mia]

I don't know at all what to use. I think I don't express myself well To put it simply, I want to have the sum of the effective projects by Fact.Code heading So for the Fact.Code heading = 2 I must get 1000 For the Fact.Code = 69 I must get 0

[ayman_salem]

Can you share a screenshot for the sample data of the two queries?

[ayman_salem]

If I understand you correctly, then you should use ForEach([Item Code Factor]).

[ju_mia]

I want to have only the table on the right, that is to say the column Fact.Code heading and the sum of effective proj.

My issue is the following : I have the left table with 4 columns:

• Icode factor Project (column 1)
• Project code (merged dimension) ==> Column 2
• Proj.Effectif (Column 3)

I wish to have the sum of the Effective Project for each Item Code Factor

Example: For the item code = 2, the sum of the effective projects is equal to 1000

So I tried the following formula: Sum [(Effective Project)] ForAll([Item Code Factor])

but it gives me the result 1,050 on all the rows of the table.

I don't know if I was clear ?

[ayman_salem]

Your explanation of the problem you are having isn't clear enough to give you a possible correct answer. Can you explain it much better?