Forum Discussion

novotnajk's avatar
novotnajk
Resolver I
4 years ago
Solved

Counting Employees between Values

Hello!   I am trying to aggregate and count patients based on their claims spend. Here is a sample table:   patient_id         Medical     Rx ABC123             $50,000    $10,000  DEF123     ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi novotnajk ,

     

    Check the formulas.

    Claim Range = calculate(average(Claim[claim_range]))

Claim Range 50% = [Claim Range]*.50

High Cost Patients = CALCULATE(DISTINCTCOUNT(Patient[patient_id]),FILTER(Patient,Patient[Total Spend]>=Claim[Claim Range]))

High Cost Patients 50% = CALCULATE(DISTINCTCOUNT(Patient[patient_id]),FILTER(Patient,Patient[Total Spend]>=Claim[Claim Range 50%]&&Patient[Total Spend]<Claim[Claim Range]))

     

    Best Regards,

    Jay

novotnajk's avatar
novotnajk
Resolver I
4 years ago

Hi Ashish,

 

I was hoping to avoid another filter (proportion).  If there a way to build the proportion you've highlighted above into a measure?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

The input of 50% or 40% has to be a user input - that's why i built that table manually.