creating relationship between two visuals from two unrelated tables

[Zabeer]

Hello everyone. I have a rather strange question.

I have two table visuals derived from two completely unrelated tables (no relationship existing between them) after applying a few slicers and filters. However, i wish to add another column to the second visual based on the 'count' column in the first visual. More details below.

First Visual :

Date             Category              Count

01/01/2020         A                      2

02/01/2020         A                      4

05/04/2020         A                      3

12/06/2020         A                      1

Second visual :

CUS        Hours    New column to be added = Hours * Count

abc         5              10

abc         7              28

abc         6              18

abc         3              3

Is this even possible? Is there a way to index the rows (one thing remains constant : number of rows in both the visuals)?

Thanks

[dax · Accepted solution]

Hi @Zabeer , 

I think you could create an index like below, then use measure to get this result

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Zabeer , there should be some common dimension to create a correct calculation