set expression

[#1]

Hi

i have a table

Event Id	Date
121	4/27/2012
122	4/27/2012
123	4/25/2012

i need to count event ids with unique Date, in the above example it should return 2

[lironbaram]

hi try

count(distinct Date)

[#3]

that would return desired count but i want to count eventids due to other limitations

i have a table

Event Id	event name	Date
121	abc	4/27/2012
122	abc	4/27/2012
123	abc	4/25/2012
124	xyz	4/25/2012

in this table event 'abc' occured twice and 'xyz' occured once , so now the expression should return count of events 3

[lironbaram · Accepted solution]

so you can add

count(distinct Date&[event name])

basicly i would prefer not using set analysis in my expressions

try to keep it  as simple as possible

[somenathroy]

This is snap of a straight table.