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
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 |