Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have these table:
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:
These slices only work in the table they were taken from:
In my case total target for 2018 is 70.
How can I create a relationship to change the values in both tables?
Thank you!
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |