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
Thanks in advance.
Solved! Go to Solution.
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:
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.
Add these 3 Measures to your summary (Dim) Table. Then drag them into a Table as Values
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?
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.