Forum Discussion

sd_parekh's avatar
sd_parekh
Helper I
3 years ago
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...
  • lukiz84's avatar
    lukiz84
    3 years ago

    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)
  )

     

  • lukiz84's avatar
    lukiz84
    3 years ago

    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

     

sd_parekh's avatar
sd_parekh
Helper I
3 years ago

In value section I used column value. Its stored in table.

I wrote "CountL2W days" dax function however power bi did not allow me to drop that measure into row section.

If I drop that function into the value section it creates group with attendance code.

Refer attached image. 

Also If I use same measure in a matrix of value section without attendance code field it shows me the correct result but I need first matrix which will have last column named  "CountL2W days" same as second matrix.