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.
Hi !
Please, help with this "simple" task.
I have some source table:
And I want to show result table like this:
In Result table first column (yellow) - users from Source table from column User who log time (also yellow).
I know how to calculate LogTime, but I can't calculate second column - N of unique assets which displays how many tasks the user owns, who logged the time.
How i try to do it:
1) create virtual table via SUMMARIZE and get via LOOKUP needed values. But I can't reference the columns of the virtual table via LOOKUP
2) via FILTER:
measure "[# of Assets]" to calculate N of unique assets for task owners =
But it's not working.
Please help solve this problem
Solved! Go to Solution.
@Vitaliy
Add this as a measure:
Unique =
SUMX(
SUMMARIZE(
FILTER(
ALL('Source table'),
'Source table'[Task owner] = MAX('Source table'[User who log time])
),
'Source table'[Task ID], "_V", MAX('Source table'[N of assets for task]) ),
[_V]
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Vitaliy
Add this as a measure:
Unique =
SUMX(
SUMMARIZE(
FILTER(
ALL('Source table'),
'Source table'[Task owner] = MAX('Source table'[User who log time])
),
'Source table'[Task ID], "_V", MAX('Source table'[N of assets for task]) ),
[_V]
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Vitaliy , Create a user table and join Task owner and User who log time. One join will be inactive.
Activate the join using use relation.
Log time is based on User who log time join.
Another one is based on ask owner
refer
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 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |