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,
I am trying to work out the Training Status % based off all subjects vs completed subjects.
For one customer, the total subjects to be completed are 4 (account id 1) and another 49 (account id 2) for example
My calculations are:
Table 1 | Incorrect | Incorrect | |||
Client | Account id | Zone | Subjects All | Completed Subjects | Training Status % |
CLA | 1 | Pizza | 3 | 3 | 100% |
CLA | 1 | Cake King | 3 | 3 | 100% |
CLA | 1 | Fish | 3 | 1 | 33% |
CLA | 1 | Milk Shake | 2 | 1 | 50% |
CLA | 1 | Coffee | 4 | 3 | 75% |
CLA | 1 | Pies | 3 | 2 | 67% |
CLA | 1 | Burgers | 3 | 2 | 67% |
Table 2 | Correct | Correct | |||
Client | Account id | Zone | Subjects All | Completed Subjects | Training Status % |
CLA | 1 | Pizza | 4 | 3 | 75% |
CLA | 1 | Cake King | 4 | 3 | 75% |
CLA | 1 | Fish | 4 | 1 | 25% |
CLA | 1 | Milk Shake | 4 | 1 | 25% |
CLA | 1 | Coffee | 4 | 3 | 75% |
CLA | 1 | Pies | 4 | 2 | 50% |
CLA | 1 | Burgers | 4 | 2 | 50% |
Thanks
Solved! Go to Solution.
Hi, thank you so much. I managed to add a calculated column
Hi, thank you so much. I managed to add a calculated column
Hi @ClaireBear. Try this for your total subjects measure:
Total Subjects =
CALCULATE (
DISTINCTCOUNT ( 'Dimension Subject'[SubjectID] ),
ALL ( 'Dimension Subject' )
)
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |