Forum Discussion

mafaber's avatar
mafaber
Icon for Helper II rankHelper II
6 years ago

Using related in a measure

Hi,   simply put I have 2 tables, one containing number of items shipped, and a dim table containing cubic meters (CBM) of each product. They have an active relationship set up based on a product I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi!
You have to create a row context in your formula if you want to avoid the calculated column.

Example of RELATED in a measure 
Measure=
SUMX(
TABLE,
COLUMN1*
SWITCH(
TRUE(),
CONDITION USING RELATED,
1,
-1
)