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

Thanks again. ğŸ˜€ . Can I ask you one more question? 

lukiz84's avatar
lukiz84
Memorable Member
3 years ago

sure 🙂

  • lukiz84's avatar
    lukiz84
    Memorable Member
    3 years ago

    sure just send me a private message anytime 🙂

  • sd_parekh's avatar
    sd_parekh
    Helper I
    3 years ago

    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

     

     

  • lukiz84's avatar
    lukiz84
    Memorable Member
    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

    Hi,

    Thanks for your help one more time.

    Is there any way I can contact you directly if I have any question, of course with power bi community.