How to NOT total a column in matrix

[admin_xlsior]

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. How to hide this ?

Also it is strange whereby I put a rule like this :

but it looks the icon is black (which is the original color). But anyway I want to hide it.

Thanks,

[mahoneypat · Accepted solution]

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]

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]

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