Excluding certain values from a table

[cseward1963]

Hello All.  I have a table with several dimensions and billing category totals.  One of the dimensions is Student ID.  If possible, I'd like to exclude Student ID = 0 (zero).  Student ID zero  refers to "Non-Student" time (traveling, etc). 

Thanks.

[sunny_talwar]

May be use this in your expression

{<[Student ID] -= {'0'}>}

[cseward1963]

Hi Sunny.  Where would I place this expression?

Also, unrelated to this, I added a profile picture to my profile and it doesn't who on my name icon.  Do you see my profile picture?

[OmarBenSalem]

you add it in ur measure:

sum({<[Student ID] -= {'0'}>}YourMeasure)

to answer ur second question: u add ur photo as an AVATAR so that It can be seen when u comment

[cseward1963]

THank you Omar.  StudentID is not a measure, it is a dimension.

[sunny_talwar · Accepted solution]

You can do like this

If([Student ID] = 0, Null(), [Student ID])

[cseward1963]

Thank you Sunny, this worked!  and I learned something useful !