Forum Discussion

sd_parekh's avatar
sd_parekh
Icon for Helper I rankHelper I
4 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
    4 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
    4 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

     

lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
4 years ago

sure 🙂

sd_parekh's avatar
sd_parekh
Icon for Helper I rankHelper I
4 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
    Icon for Memorable Member rankMemorable Member
    4 years ago

    sure just send me a private message anytime 🙂

  • lukiz84's avatar
    lukiz84
    Icon for Memorable Member rankMemorable Member
    4 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
    Icon for Helper I rankHelper I
    4 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.