Matrix not showing correct Ground and subtotal

[moeconsult]

Please see attached Matrix, I am doing disticnt count of attendance so all value returned for each colomn are 1 but the report is also showing Total as 1 which is wrong,  I need help with this as soon as possible thanks.

[v-xuding-msft]

Hi @moeconsult ,

You could try the function of SUMX firstly, like this:

Measure = SUMX(Your_Table,[That_Measure])

The attachment is not working. If the formula can't help you, please attach a new one.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[moeconsult]

Please see sample data and Table report. What I want to create a matrix with my report.

I have students attended different sessions from different schools and regions. One student can have many sessions booked but it doesn't matter as I want am after is to Unique of the earliest attendance as u can see Bronte school appeared 3times but I want the first time they attendede  using the attendance column and date . I hope my explanation is good enough . Thanks. and the date. Date and phase be used as Filter.

EVENTED Table
Org Name	Stage
Bronte School	Primary
Ola School	Secondary
Jame School	Other					Sampple Table Report
						Region	LP	OrgName	Date
Sess Table					NE	North Jam	Bronte School	02/03/2020
Attendance	Status					NE	North Jam	Bronte School	18/03/2020
10090	Attended					NE	North Jam	Bronte School	19/03/2020
10080	Absent					NW	North West	Ola School	19/03/2019
10070	Pending					EN	East North	James School	18/03/2020
Contractors Table
Region	LP
NE	North Jam
EN	East North
NW	North West
Time Table
02/03/2020
18/03/2020
19/03/2020

[amitchandak]

To sum up the line level values of distinct you need a context. You need to try one of the following. Values or summarize to give a group by context

sumx(values(table[ID]),[Measure])
sumx(summarize(table,table[ID],"_dist",[Measure]),[_dist])