Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

How to NOT total a column in matrix

Hi all,   I got a requirement of an indicator in my Matrix table. So I added a measure with only UNICHAR(11044), which is a circle. But I saw in Total (Subtotal and Grand total), this included in. ...
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You could replace HASONEVALUE with ISINSCOPE or HASONEFILTER on your Product ID column.  That should do it.  Also, you can search for Unichar lists to find ones like this one.  It shows White Circle is 25CB I think.

    List of Unicode characters - Wikipedia

     

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Your column name is hidden, but basically just wrap your measure in IF(HASONEVALUE(Table[Your Column]), [YourMeasure])

The total rows will have multiple values and return blank.

Regards,

Pat

  • admin_xlsior's avatar
    admin_xlsior
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Hi mahoneypat 

     

    It looks working, but with some exception. I changed the measure to be like this:

    KPI icon = IF(
                HASONEVALUE('Product'[Item id]),
                UNICHAR(11044),
                BLANK()
)


    The grouping which is the Product group, if by any chance the  Group contain only 1 item number, it will still shows that "black/original" circle.

     

    How to get the list of UNICHAR btw ? got an idea, why not show the original as white circle. What is the UNICHAR for white circle ?

     

    Thanks