Amount of other products

[Antmkjr]

https://drive.google.com/file/d/1NYg6zhVHJgWBvs2sMiTq5bOq2_B0W9xW/view?usp=sharing

In the above file,  is a report , with prod as filter ,

Eg if i select A,  table visual will show me , what other products have people who purchased A also bought.

So in this case output when i select A as prod filter :

C

D

E

If i select D, the output :

A

C

E

B

Now I need to have Amount and distinct count of ID to the table

Expected Output:

Prod	AMount
E	15
D	6
C	8

[daXtreme · Accepted solution]

File attached. Good modeling techniques go a long way toward making things easy... If this solutions meets your requirements, please mark it as the solution. It'll help others. Thanks. 

[johnt75]

You can create a couple of measures like

Sales Amount = IF( NOT ISBLANK([_]),CALCULATE( SUM( 'SALES'[Amount] ), REMOVEFILTERS( PROD ) ) )

Count of ID = IF( NOT ISBLANK([_]), CALCULATE( DISTINCTCOUNT( SALES[ID] ), REMOVEFILTERS( PROD ) ) )