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.
Solved! Go to Solution.
@Anonymous
If you add on the table the User as Dimension and the Measure (No of Teams) you will see the number of teams per user.
Make sure to click on the table and on the user field on Visualisations Panet o do right click on it and select Don't Summarise. This is actualy causing the problem.
Also change the formula to this one:
No of Teams = DISTINCTCOUNT(Table[Team_Name])
Workspace on this link:
Hi @Anonymous
Use the Count with filter ALLEXCEPT
CALCULATE(COUNTA(Table1[username]),ALLEXCEPT(Table1,Table1[username]))
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
@Anonymous
First create a measure which simply counts the number of teams.
e.g. No of Teams = COUNT(Table[Team_Name])
Then create a table object with users as dimension and No of Teams as a measure.
Then on Visualisations Pane go to "Visual Level Filter" and add the Measure there.
Go to filter type --> advanced filtering --> is greater than 2
@Anonymous
If you add on the table the User as Dimension and the Measure (No of Teams) you will see the number of teams per user.
Make sure to click on the table and on the user field on Visualisations Panet o do right click on it and select Don't Summarise. This is actualy causing the problem.
Also change the formula to this one:
No of Teams = DISTINCTCOUNT(Table[Team_Name])
Workspace on this link:
@Anonymous
Just Create a new table object right next to the previous one and have User as Dimension and Team Name next to it (both as dimensions). The on Visual level filters add again the restriction greater than 2.
Then you will see the team names per user.
I hope this is what you want?
It wouldn't show it all as I wanted so I went with a matrix in the end, but this was great thanks so much for your help!
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |