Skip to Content
avatar image
Former Member

Counting Customers Based On Calculated Measure

My goal is to define customers as single property or multi property based on number of collateral pieces. I created a [collateral count] measure. Where I'm stuck is counting how many of my customers have [collateral count]>1 and how many have [collateral count]=1.

My table looks like this

Customer Collateral Count

A 1

B 1

C 2

I need my result to be

Property Type Customer Count

Single 2

Multi 1

I've beet able to create a measure that indicates single or multi, but have not been able to count these items.

Any help would be appreciated!

Jay

What I have so far:

sample-data.png (5.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 27, 2017 at 03:14 PM

    use sum function to get the total count for single or multi.

    =Sum([Single variable])

    Add comment
    10|10000 characters needed characters exceeded