Forum Discussion
rows in matrix?
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 |
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:
1 Reply
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: