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.
Hallo
I have two colums in below
I need to create a group by category and grade ( content and not the colums)
For example :
Artisan T07 or Technician T11
I will then apply my calcualted usage to each of these and it will show what Category and grade has the usage.
Instead of creating calculated tables for each group I need ( 16 in total ) is there another way ?
Grade | Category |
M18 | Managerial |
M18 | Managerial |
M16 | Managerial |
M18 | Managerial |
M18 | Managerial |
P18 | Managerial |
T06 | Tech Non-Sup |
T05 | Non-Tech Non-Sup |
T09 | Non-Tech Non-Sup |
EEE | Executives |
T09 | Non-Tech Non-Sup |
T09 | Tech Non-Sup |
M15 | Managerial |
T12 | Non-Tech Non-Sup |
T10 | Non-Tech Non-Sup |
T10 | Non-Tech Non-Sup |
F Band | Executives |
@Valnus , The information you have provided is not making the problem clear to me. Can you please explain with an example?
Appreciate your Kudos.
Hi
Ok so inside the two colums is information I need to group ( Combine Managerial & M18) and report on
So le't's say Managerial M18 is one group and Managerial M16 is another.
The amount of people I have will each contribute to the total of the above groups.
So Managerial M18 = 10 & Managerial M16 = 20
I have 16 of these groupings that I need to display
If my total people is 30 ( I have the measure so don't worry about that )
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |