Need to sum the values of three counts in a KPI chart expression

[fors_gregg]

I'm building a sheet with KPI's counting cases by how long it took to take action, and whether they still are awaiting action.

It's the final one that is giving me difficulty.

It should be easy: Total Count, minus "#<90", minus "#>90" = Remainder

But this does not work:

=Sum({<Count(distinct CMPLN_NBR)-Count({<[ELAPSED_DAYS]={"<=90"}>} distinct CMPLN_NBR)-Count({<[ELAPSED_DAYS]={">90"}>} distinct CMPLN_NBR))>} distinct CMPLN_NBR)

Thanks for your suggestions!

[poklegoguy]

You can try to use the RangeSum function to get the sum of multiple measures:

RangeSum(Count(distinct CMPLN_NBR), Count({<[ELAPSED_DAYS]={"<=90"}>} distinct CMPLN_NBR), Count({<[ELAPSED_DAYS]={">90"}>} distinct CMPLN_NBR))