rows in matrix?

[Anonymous]

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

[DataInsights · Accepted 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: