Help with a measure

Hi redhughes,

---

 Then, ideally there would be a row or another visual that states how many clients' ratio was below our target (let's say 0.428).

If I understand it correctly, you should be able to use the formula below to create a new measure to calculate how many clients' ratio was below the target(0.428). :smileyhappy:

Measure =
SUMX (
    SUMMARIZE (
        Sheet1,
        Sheet1[Client],
        "abc", IF ( [EmployeesToVisitsRatio] < 0.428, 1, 0 )
    ),
    [abc]
)

Regards