Forum Discussion
Post ProdigyHow 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. 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,
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
3 Replies
- mahoneypat
Microsoft Employee
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_xlsiorHi 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