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 two different lists that have a similar structure columnwise , like the following:
Date (D) | Machine (ID) | Time Spent (h)
--------------------------------------------
The Lists are connected by the Column Date in both directions enabling crossfiltering.
i am trying to create a Dashboard in form of a table where i can see the total time that was spend on one machine h1 and h2 and the added time from both tables h3.
----------| Day 1 | Day 2 | Day 3 | Day 4 | ......
Machine 1 h1|h2|h3
Machine 2
Machine 3
Machine 4
...
My Goal is, that only the task that was performed the same day on the same machine ist listed in the table.
Instead the total amount of all task of all machines from list 2 is listed in the table.
For example:
List 1:
Date (D) | Machine (ID) | Time Spent (h)
20.02.18 | M1 | 3h |
21.02.18 | M1 | 4h |
List 2:
Date (D) | Machine (ID) | Time Spent (h)
20.02.18 | M1 | 7h |
Result:
----------| 20.02.2018 | 21.02.2018 | Day 3 | Day 4 | ......
Machine 1 3h | 7h | 4h
Machine 2 7h
Machine 3 7h
Machine 4 7h
...
I dont know how to enable, that it will also filter for the machine ID and not only for the date.
Any help would be appreciated.
Thank you a lot.
Solved! Go to Solution.
@simzik ,
You may apply virtual relationship in DAX measure.
@simzik ,
You may apply virtual relationship in DAX measure.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |