Creating Measure DAX

[srlabhe]

Hi All,

I have below calculated column created 

$COGS = if(related('GL Account Dim'[ACCOUNT_GROUP])="INVOICED_PRICE" && 'Gross Profit Details'[PROFIT_CENTER]="19003",'Gross Profit Details'[AMOUNT]*0.681,

if(related('GL Account Dim'[ACCOUNT_GROUP])="COGS - SAP",'Gross Profit Details'[AMOUNT],0))

Need to convert into Measure DAX, but when I try to use IF or Switch it doesnt allow me to use Related,

Help appreciated

[v-binbinyu-msft · Accepted solution]

Hi @srlabhe ,

The RELATED function needs a row context; therefore, it can only be used in calculated column expression, where the current row context is unambiguous, or as a nested function in an expression that uses a table scanning function. A table scanning function, such as SUMX, gets the value of the current row value and then scans another table for instances of that value.

Please adjust your dax formula.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.