Forum Discussion
DAX HELP
- 6 years ago
Hi, Anonymous
I am unable to access the link. For further information, please show us a valid link. So I create data to reproduce your scenario.
TableA:
TableB:
There is a many-to-one relationship between two tables.
You may create a measure as follows.
SumQuantity = var _result = SUMX( RELATEDTABLE(TableB), TableB[Quantity] ) return IF( _result= 0, 0, _result )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
I am unable to access the link. For further information, please show us a valid link. So I create data to reproduce your scenario.
TableA:
TableB:
There is a many-to-one relationship between two tables.
You may create a measure as follows.
SumQuantity =
var _result =
SUMX(
RELATEDTABLE(TableB),
TableB[Quantity]
)
return
IF(
_result= 0,
0,
_result
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.