Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Zabeer
Helper I
Helper I

creating relationship between two visuals from two unrelated tables

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

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
dax
Community Support
Community Support

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.