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.
I have a table with multiple columns. One Column is called Lic Type and another is called User.
There are six different Lic Types and multiple users can be in each Lic Type.
I want to group my report by Lic Type and after each Lic Type I want a count of the number of users from the User column for each different Lic type.
Any ideas.
Thanks.
Solved! Go to Solution.
Something like this?
Proud to be a Super User!
Hi @PowerBrowse ,
I think you can try ALLEXCEPT() function to create a measure or a calculated column.
Total Group by Lic Type =
CALCULATE (
DISTINCTCOUNT ( 'Table'[User] ),
ALLEXCEPT ( 'Table', 'Table'[Lic Type] )
)
Result is as below.
OR
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Both answers were of help.
Thanks.
Number of users = COUNT(Table[User])
Proud to be a Super User!
Thanks for the reply but I think you misunderstood.
I need the Number of Users for each Lic Type in the form. Each user has a Lic Type and there are 6 different Lic Types in the table.
So.... I still don't understand. Can you post here sample rows with the data you have an what do you expect from that data? It's very hard to understand what do you mean only by description.
Proud to be a Super User!
Lic Type | User |
Admin | Denise |
Read | Simon |
Write | Carl |
Read | Julia |
Read | Laura |
Admin | Peter |
Read | Bob |
I want to Group each Admin, Read, and write group. After each group I want to print the number of each Lic type i.e after Admin I want to print "Total = 2" because there are 2 Admin users. After Read group I want to print "Total = 4" because there are 4 Read Lic Types.
Hi @PowerBrowse ,
I think you can try ALLEXCEPT() function to create a measure or a calculated column.
Total Group by Lic Type =
CALCULATE (
DISTINCTCOUNT ( 'Table'[User] ),
ALLEXCEPT ( 'Table', 'Table'[Lic Type] )
)
Result is as below.
OR
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Something like this?
Proud to be a Super User!
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 |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |