if and count

[new_guy]

Hello guys,

I want to create a KPI which should first check a field of one column and if the condition applies count the rows of an other column.

I went with the following:

count (if([FIELD_NAME]="EXPRESSION"), distinct [COLUMN_NAME])

I tried several other ways but nothing worked yet. Any suggestions? Thanks in advance!

[pradosh_thakur]

something similar
count(distinct{<FIELD_NAME ={"EXPRESSION"}>} [COLUMN_NAME])

or

sum(if([FIELD_NAME]="EXPRESSION",1,0))