setting count condition for KPI

[nsigitsutanto]

Hello, I would like to set a condition for KPI. So, the problem is I have two columns consist of two dates. These dates refer to planned date and execution date. I would like to count how many item that has different dates and show the total of these items with KPI. What expression that I could use to do this condition? Thank you.

[da_pagnott]

Hi,

could be something like this, to count how many days you have in your column DATE that are different from Date 1 and Date 2.

=Count({<DATE=-{"$(=Date2)","$(=Date1)"}>} distinct DATE)