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
sea
Frequent Visitor

relationship table not work

Hello,

 

I have these table:

Screenshot_1.png

 

I have the following relationships between the tables:

activities->id_user = users->id_user ----both

target->id_user = users->id_user ----both

 

I have this slicers:

Screenshot_2.png

 

These slices only work in the table they were taken from:

Screenshot_3.png

In my case total target for 2018 is 70.

 

How can I create a relationship to change the values in both tables?

 

Thank you!

 

 

3 REPLIES 3
ricardocamargos
Continued Contributor
Continued Contributor

Hi @sea,

 

This filter doesn't affect the target table because the relationship is just on "id_user".

When you select a year on "Activities" table it simple gets all rows from Target table (or filtering by users).

 

Do you wanna compare the target per day of activities ? If yes, you can use the append function on those 2 tables.

 

Let me know if I can help you.

 

Thanks, 

 

Ricardo

I want to see the target and the activities for the selected year.

ricardocamargos
Continued Contributor
Continued Contributor

@sea,

 

You can append those 2 tables and either filter by the same data field or create a new date table.

I tried it here, when I select "2018" it gives me 210. I think it's correct once you have 3 users, right ? 

About the activities, are u gonna count the numbers of dates ? If yes, you can count the number of dates where the column "target_activities" is blank after append those tables.

 

 Tks,

 

Ricardo

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.