DAX grouping by linked dimension

[ikibirev]

Hi!

I have a table with facts that are linked to the dimension table by the Item attribute. And the dimension table has another attribute – LinkedItem.

I want to get DAX calculation LinkedAmount that for each Item calculates amount of all fact lines where that item is presented as a LinkedItem.

Something like this:

Dim.Item	Dim.LinkedItem	Facts.Amount		LinkedAmount
Item1	Item4	10		0
Item2	Item4	20		0
Item3	Item4	30		5
Item4	Item3	5		60

Please advise how formula should look like.

Thanks in advance!

[amitchandak]

I am not sure I got it completely. But please try.

Create a relation between linked item and item dim. Make sure it is inactive. Create a formula so facts amount using that relation. Use userelation. As you will view at the item, because of the join it should give you the required data.

Refer to this example of how to shift relation

https://community.powerbi.com/t5/Desktop/DATE-RANGE-SLICERS-TO-COMPARE-NETSALES-OF-A-DATE-RANGE/td-p...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.