Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
This may be a dumb question, I am new to PBI, but any help would be appreciated.
I have been ask to recreat this report using PBI
01-Jan | 01-Feb | 01-Mar | 01-Apr | Grand Total | |
Sum of attended | 29 | 4 | 33 | 37 | 103 |
Sum of maxPlaces | 65 | 10 | 60 | 55 | 190 |
% filled | 45% | 40% | 55% | 67% | 54% |
and this is the data: ( I have simplified the report and data )
date | event | attended | maxPlaces |
01/01/2022 | type1 | 3 | 10 |
01/02/2022 | type1 | 4 | 10 |
01/03/2022 | type1 | 5 | 10 |
01/04/2022 | type1 | 3 | 10 |
01/04/2022 | type1 | 7 | 10 |
01/01/2022 | type2 | 11 | 20 |
01/01/2022 | type2 | 13 | 20 |
01/03/2022 | type2 | 10 | 20 |
01/04/2022 | type2 | 18 | 20 |
01/01/2022 | type3 | 2 | 15 |
01/03/2022 | type3 | 11 | 15 |
01/03/2022 | type3 | 7 | 15 |
01/04/2022 | type3 | 9 | 15 |
Solved! Go to Solution.
Try these measures:
Sum of Attended = SUM ( Table1[attended] )
Sum of maxPlaces = SUM ( Table1[maxPlaces] )
% filled = DIVIDE ( [Sum of Attended], [Sum of maxPlaces] )
Add all three measures to the Values field well of a matrix, and toggle "Switch values to rows" on:
Proud to be a Super User!
Try these measures:
Sum of Attended = SUM ( Table1[attended] )
Sum of maxPlaces = SUM ( Table1[maxPlaces] )
% filled = DIVIDE ( [Sum of Attended], [Sum of maxPlaces] )
Add all three measures to the Values field well of a matrix, and toggle "Switch values to rows" on:
Proud to be a Super User!
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |