Forum Discussion
redhughes
Helper II
Helper IIHelp with a measure
Hi, I was wondering if someone could help me solve a problem. The data I have looks like this: What I want to achieve is a table that shows how many visits each client had, how m...
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
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeHi 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
