Calculate unique count of lower level within higher level

[Braveen]

I have a table structure that looks like below, I would like to calculate count of states column.

I tried Aggr(count(distinct state), zone) which gives me result for one record per zone and remaining are blank.

Any idea on how to calculate this would be great.

[marcus_sommer]

If you want to ignore selections you may apply something like:

count({< State >} total <Zone> Field)

[Braveen]

Tried this: count({< State >} total <Zone> Field), After applying the filter for state, metrics go blank for all states but the filtered value. Meaning, all states are still visible even after I applied the filter with correct count of states within the zone

Tried this too, aggr(count( {<State=>}distinct State), Zone) and this is giving me desired result.