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 All
I have an employee table relataionship modelled to a activity table by email.
I use the following to return my count
Role_ID | UserName | Location | BA Role | GAZROLE_BA_TOTALCount1 | |
1 | Mike.user | Town | BA Wearer | blah1 | 1 |
2 | Dave.user | City | BA Wearer | blah2 | 1 |
3 | Joe.user | City | BA Wearer | blah3 | 2 |
8 | Paul.user | Town | BA Wearer | blah5 | 1 |
Role_ID | UserName | Location | BA_ Role | answer | activity_date | |
1 | Mike.user | Town | BA Wearer | blah1 | Required Standard Achieved | 01/01/2023 |
2 | Dave.user | City | BA Wearer | blah2 | Required Standard Achieved | 03/02/2023 |
2 | Dave.user | City | BA Wearer | blah2 | Not Assessed | 04/03/2023 |
2 | Dave.user | City | BA Wearer | blah2 | Required Standard Achieved | 21/06/2021 |
3 | Joe.user | City | BA Wearer | blah3 | Required Standard Achieved | 27/12/2021 |
6 | Andy.user | Town | BA Wearer | blah4 | Required Standard Achieved | 12/08/2021 |
3 | Joe.user | City | BA Wearer | blah2 | Required Standard Achieved | 20/07/2021 |
8 | Paul.user | Town | BA Wearer | blah5 | Required Standard Achieved | 16/03/2023 |
Role_ID | UserName | Location | |
1 | Mike.user | Town | blah1 |
2 | Dave.user | City | blah2 |
3 | Joe.user | City | blah3 |
6 | Andy.user | Town | blah4 |
8 | Paul.user | Town | blah5 |
10 | Pete.user | Town | blah6 |
11 | Will.user | City | blah7 |
Role_ID | UserName | Location |
Role_ID | UserName | Location | GAZTESTBA1 | |
1 | Mike.user | Town | blah1 | 1 |
2 | Dave.user | City | blah2 | 1 |
3 | Joe.user | City | blah3 | 2 |
6 | Andy.user | Town | blah4 | 0 |
8 | Paul.user | Town | blah5 | 1 |
10 | Pete.user | Town | blah6 | 0 |
11 | Will.user | City | blah7 | 0 |
Solved! Go to Solution.
@gazzo1967 Try adding +0 to your measure.
@gazzo1967 Try adding +0 to your measure.
@Greg_Deckler
You know what!!
I'm so annoyed with myself because I did that but put the '+0' in the wrong place!!😡
I put it before the last bracket rather than after..
everydays a school day lol
Thanks Greg 🙂
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 |
---|---|
101 | |
99 | |
76 | |
67 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |