Forum Discussion
ania_roh
Helper III
Helper IIIproblem with Dax measure
Hello, I need some help in building my measure because I can´t find a way. I would be very grateful if you could help me. So, I have three columns (in the same table): column of localization_desti...
FreemanZ
Super User
Super Userhi ania_roh
that was something never mentioned, try like
Y =
VAR _dest = MAX(TableName[DestOrig])
RETURN
SUMX(
FILTER(
ALL(TableName[Dest], TableName[DestOrig] ),
TableName[Dest] = _dest
&&TableName[DestOrig] <> _dest
),
TableName[Value]
)
- FreemanZ
hi ania_roh
try like:
Y2 = VAR _dest = MAX(TableName[DestOrig]) RETURN CALCULATE( SUM(TableName[Value]), TableName[Dest] = _dest, TableName[DestOrig] <> _dest )this one takes filters on other column, like:
the sample dataset:
SectionDestDestOrigValue
A 1111 1111 1 B 1111 2343 6 C 1111 2345 9 A 2343 1111 2 B 2343 1111 7 C 2345 2345 3 A 3456 3456 5 A 7642 3456 4 B 7642 7642 8 C 7642 4582 10