Using Calculate inside SUMX to get a calculation -> Parameter is not the correct type

[Ricardo77]

Hello,

inside SUMX i'm iterating over a FACTUAL, doing something like (x/a)*(a'-a), where a' is DIMENSION(SOMEVALUE2) under a different context CODE_MOMENT_T_1 (all the other "code" runs under CODE_MOMENT).

So i think that line could also be something like 
CALCULATE(RELATED(DIMENSION[SOMEVALUE2]); FACTUAL[CODEMOMENT] = CODEMOMENT_T)

but the moment i do this, RELATED(DIMENSION[SOMEVALUE2]) gets underlined and i got an error message saying "Parameter is not the correct type. Cannot find name [SOMEVALUE2]"

RESULT  = 
VAR SELECTED_2_MOMENTS = ALLSELECTED(FACTUAL[CODEMOMENT])
VAR CODEMOMENT_T =   CALCULATE(MAX(FACTUAL[CODEMOMENT]); FACTUAL[CODEMOMENT] IN SELECTED_2_MOMENTS) 
VAR CODEMOMENT_T_1 = CALCULATE(MIN(FACTUAL[CODEMOMENT]); FACTUAL[CODEMOMENT] IN SELECTED_2_MOMENTS)

RETURN IF (CODEMOMENT_T <> SELECTEDVALUE(FACTUAL(CODEMOMENT); 
            CALCULATE (
                SUMX(
                    FACTUAL;        
                    DIVIDE(FACTUAL[SOMEVALUE]; RELATED(DIMENSION[SOMEVALUE2])) 
                    *
                    -- calculation problem next line 					
                    
(CALCULATE(MAX(DIMENSION[SOMEVALUE2]); FACTUAL[CODEMOMENT] = CODEMOMENT_T; CROSSFILTER(FACTUAL[ID_CONCATENATED_ENTRY]; DIMENSION[ID_CONCATENATED_ENTRY]; OneWay))
		  
                    - RELATED(DIMENSION[SOMEVALUE2]))  
                    ;
                    FACTUAL[CODEMOMENT] = CODEMOMENT_T_1)
           )            

Can someone help me out?

[amitchandak]

@Ricardo77 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Ricardo77]

Hello @amitchandak , thanks for your help & time,

to be sincere, i already posted the question with more detail , under this link
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-get-the-value-from-the-same-table-but-...

If you could help i would be very thankful (Y)