Hi All, I want to exclude null and other value in an <column> but while showing the count i need count including null and other. Any specific approach for this. Thanks for your help in advance Regards, Venkatesh.

Hi @Venkatesh Seelam​ 

• You want to filter out some values (e.g. NULL and "Other") from the visual.
• But you still want the total count (including NULL and "Other").

Approach:

1. Create a calculated field for filtering

IF ISNULL([Column]) OR [Column] = 'Other' THEN 'Exclude' ELSE 'Include' END

2. Drag this calculated field to Filters

Keep only Include — this will exclude NULL and 'Other' from the visual.

3. In your count calculation (for the label / total), do not use the filter directly.

COUNT([Column])