Total Count

[superjermsss]

Hi Everyone,

I need help formulating how to calculate the total number of invoices shown below. I want the total number of invoices to display zero if the count only reflects resolved invoices, or if the number of resolved invoices exceeds the pending status and additional items.

Below is my current formula.

=Count(distinct{$<[Daily Comparison-2.Report Date]={'4/8/2026'}>}[Daily Comparison-2.Invoice Number]) + Count(distinct{$<[Daily Comparison-2.Status]={'Additional items'}>}[Daily Comparison-2.Invoice Number])
- Count(distinct{$<[Daily Comparison-2.Status]={'Resolved'}>}[Daily Comparison-2.Invoice Number])

[marksouzacosta]

Hi @superjermsss ,

What about this?

=RangeMax(Count(distinct{$<[Daily Comparison-2.Report Date]={'4/8/2026'}>}[Daily Comparison-2.Invoice Number]) + Count(distinct{$<[Daily Comparison-2.Status]={'Additional items'}>}[Daily Comparison-2.Invoice Number])
- Count(distinct{$<[Daily Comparison-2.Status]={'Resolved'}>}[Daily Comparison-2.Invoice Number]),0)

Regards,

Mark Costa