PowerPivot- DAX - Why I can't use "RELATED" Dax in the Calculated Fields?

[paulkltam]

PowerPivot -Just wondering how why I cannot use "RELATED" Dax in the Calculated Fields, but I can use in the Calculated Columns? Can anyone explain to me? Thanks.

 

[paulkltam]

I mean it shows error in the area in the calculated area.

 

[seatown1two]

You can, though your expression which uses the related function needs to be wrapped in one the the "X" functions.

Ex.
Total Revenue:=SUMX(fTable,fTable[Count]*RELATED(dTable[ProductCost])) {SUMX(table,expression)}

 

[esadovnic]

To clarify a bit of seatown1two's reply: the X function iterates per row, which allows for the RELATED() function to work in a measure.