Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm stuck trying to figure this out and was wandering if anyone could help guide me in the right direction.
I have 2 tables that are conntected by the UserID column, that is unique to Table 1. I also have Table 2 where actions are captured by UserID.
In Table 1, I need to create new columns based on actions and count actions per userID
Example:
Thanks in advance.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi, @simlee
You can create three Calculated columns to get the result you want.
Eat Count = CALCULATE(COUNT(Actions[Action]),ALLEXCEPT(Users,Users[UserID]),Actions[Action]="Eat")
Sleep Count = CALCULATE(COUNT(Actions[Action]),ALLEXCEPT(Users,Users[UserID]),Actions[Action]="Sleep")
walk count = CALCULATE(COUNT(Actions[Action]),ALLEXCEPT(Users,Users[UserID]),Actions[Action]="walk")
The result looks like this:
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
You may download my PBI file from here.
Hope this helps.
Add these 3 Measures to your summary (Dim) Table. Then drag them into a Table as Values
Proud to give back to the community!
Thank You!
Thank you for your comment.
I'm lost trying to drag them into a Table as Values. it's shows me the total of each action in my Dim_user Table.
Can you please guide me?
Thank you
Do you have Dim_User as a Value as well in the table? (Also, enable 'Show Items with No Data' under the User Dropdown in the Values area.)
Proud to give back to the community!
Thank You!
Actually most of my Dim_User s as list as text such as ABC12, ABC 133, ACB232....
Sorry for the confusion
Shoulnd't matter, can you provide screen shots, or more details of you table structure?
Proud to give back to the community!
Thank You!
As you can see, I need to lookup and cout the actiosn of each User in table 2 and polulate table 1 for each user.