Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ricardo77
Helper II
Helper II

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

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?

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.