Forum Discussion

rosscortb's avatar
rosscortb
Icon for Post Patron rankPost Patron
6 years ago
Solved

Count by salary ranges

Hello,

Looking for way to count the number of employess between salary ranges. 

For example. 

Employess    Salary

2                   £10,000 - £19,000

20                 £20,000 - £29,000

 

Would I need to create a measure or through power query?

 

Follow up: Did some digging and seems like I need a summarize table, but not getting the correct figures plus the date slicer iseems to have no impact on the result returned.

 

Salary Range = SUMMARIZE(Headcount,Headcount[SAP],"20000-29000",CALCULATE(COUNT(Headcount[Annual Salary]),FILTER(Headcount,Headcount[Annual Salary] >= 20000 && Headcount[Annual Salary] <= 29000)))

 

Thanks
Ross

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi rosscortb,

    You could refer to my sample to see whether this is what you want. If this is not what you want, please correct me.

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi rosscortb,

    You could refer to my sample to see whether this is what you want. If this is not what you want, please correct me.

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.