Summarize data

[PaulHallam]

Hi,

I have the following table of data
DATA_TABLE

Date	Session	Item	Percent
18-Feb-20	1	1	45.83%
18-Feb-20	1	2	0.00%
18-Feb-20	1	3	25.00%
18-Feb-20	1	4	37.50%
18-Feb-20	1	5	0.00%
18-Feb-20	2	1	66.67%
18-Feb-20	2	2	54.17%
18-Feb-20	2	3	0.00%
18-Feb-20	2	4	100.00%
18-Feb-20	2	5	12.50%
19-Feb-20	1	1	33.33%
19-Feb-20	1	2	45.83%
19-Feb-20	1	3	95.83%
19-Feb-20	1	4	0.00%
19-Feb-20	1	5	83.33%
19-Feb-20	2	1	95.83%
19-Feb-20	2	2	0.00%
19-Feb-20	2	3	29.17%
19-Feb-20	2	4	87.50%
19-Feb-20	2	5	12.50%

I am trying to represent this data in a matrix with the following layout, with the count of percentages in each date & session range.

Date	18-Feb-20	18-Feb-20	19-Feb-20	19-Feb-20
Session	1	2	1	2
Percent = 0	2	1	1	1
Percent >0%,<50%	3	1	2	2
Percent >50%	0	3	2	2

Im guessing 3 measures in the standard Power Bi Matrix but i cant get them right.

Any help greatly appreciated,

Thanks

P

[camargos88]

Hi @PaulHallam ,

Create this calculated column:

DescSession =

IF(DATA_TABLE[Percent] = 0; "Percent = 0";

IF(DATA_TABLE[Percent] > 0 && DATA_TABLE[Percent] < 50; "Percent >0%,<50%"; "Percent >50%"))

[PaulHallam]

That just adds names it doesnt sort the data or am i missing something?

[camargos88]

@PaulHallam ,

Do you want to classify the percentage column and count it by date ?