How to count a field independently of the selection made?

[acrodrigues03]

Hi,

I have a column with years and another with quarters.

I'm trying to get how much distinct values exists on the "CalendarJnJQuarterDesc" column for the selected year, but I don't want it to change the value according to the selected quarter.

I'm using the following code:

=count( DISTINCT {$<[Calendar JnJ Year]={$(=Max([Calendar JnJ Year]))}>}  [CalendarJnJQuarterDesc])

each year has 4 quarters, so it should return always 4. But if I select Q1, it changes to 1.

Can somebody help me?

Thank you ^^

[sunny_talwar · Accepted solution]

May be this

=Count( DISTINCT {$<[Calendar JnJ Year]={$(=Max([Calendar JnJ Year]))}, [CalendarJnJQuarterDesc]>}  [CalendarJnJQuarterDesc])

[acrodrigues03]

Thank you very much!