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!
Let's see if somebody knows how to do this.
I have two tables:
My objective is to get a chart with an X-axis showing the number of interactions type A achieved (up to 😎 and a Y-axis showing the number of UserID that achieved such number of interactions type A. Also, it needs to be filtered by the variable Date (time).
So, I need something that counts the number of interactions per user and afterwards something that counts the number of users with a given number of interacions.
How would you do it? I have tried different approaches but I am not able to do it. For instance, I have tried to count the number of interacions type A done using a new column on the second table, but it doesn't take into account the Date when using a filter.
Thanks in advance!
Solved! Go to Solution.
So this is going to basically look like:
Interactions Measure = COUNTROWS(FILTER('InteractionsTable',[Interaction]="A")) Users Above Threshold Measure = COUNTROWS( FILTER( SUMMARIZE('UserTable',[UserID],"__Interactions",[Interactions Measure]), [__Interactions] >= 5 ) )
For users with 5 or more interactions.
So this is going to basically look like:
Interactions Measure = COUNTROWS(FILTER('InteractionsTable',[Interaction]="A")) Users Above Threshold Measure = COUNTROWS( FILTER( SUMMARIZE('UserTable',[UserID],"__Interactions",[Interactions Measure]), [__Interactions] >= 5 ) )
For users with 5 or more interactions.
Thank you!
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 |
---|---|
107 | |
93 | |
77 | |
64 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |