Count

[dominic_marchan]

Hi all,

I have what seems to me like a simple question but cannot seem to find a solution.

I have sales and budget by items.

I want to have a KPI that shows me the count of items that have sales below budget, any ideas?

I included a simple dataset example where the count for the KPI should show 1

Thanks

[MayilVahanan · Accepted solution]

Hi @dominic_marchan 

Try like below

=Count({<Item = {"=sum(sales)<Sum(budget)"}>}DISTINCT Item)

[dominic_marchan]

Works like a charm thanks