The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
@Anonymous,
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!
@Anonymous,
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 |
---|---|
81 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |