Forum Discussion
Solved
Matrix column Subtotal
Hi all, My question is related to matrix visual. Row headers : Student name ,academic year and class name Column header: Date Values: Attendance Code Refer attached image. I want calculate co...
Hi,
looks good! Just add the zero like below:
attendance code measure = IF( HASONEVALUE(AttendanceDetails[AttendanceDate]), MIN(AttendanceStatus[AttendanceCode]), COUNTROWS( FILTER( AttendanceDetails, AttendanceDetails[AttendanceStatusId] = "2938951904584020836" ) ) + IF(COUNTROWS(AttendanceDetails) > 0, 0) )for conditional formatting you need another measure now, sorry.
just create a measure with
condFormatMeasure = SWITCH(TRUE(), [attendence code measure] = "A", 1, [attendence code measure] = "P", 2, [attendence code measure] = "PA", 3, -1 )and use this one for the rules in conditional formatting
Previously in a matrix I used AttendanceCode and I used it for conditional formating for background colour.
Now we are using Measure and measure will return value in number.
So how can we do conditional formatting using our defined measure?
Refer image
for conditional formatting you need another measure now, sorry.
just create a measure with
condFormatMeasure =
SWITCH(TRUE(),
[attendence code measure] = "A", 1,
[attendence code measure] = "P", 2,
[attendence code measure] = "PA", 3,
-1
)and use this one for the rules in conditional formatting