Forum Discussion
Show those employees with consecutive values below a certain value
Hi nftgamesendaya ,
I just want to show which employee has reached the limit. Certainly you can change it to yes or no
Target is a measure to show the certain value like 2.75 in your example.
You can alse download my pbix. file I attached below to see more details.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi nftgamesendaya ,
According to your description, I create a sample.
Here's my solution.
Create a measure.
3 consecutive =
VAR _MAX =
MAXX ( ALL ( 'Table' ), 'Table'[Week] )
RETURN
IF (
SUMX (
FILTER (
ALL ( 'Table' ),
'Table'[Week] = _MAX
&& 'Table'[Employee] = MAX ( 'Table'[Employee] )
),
'Table'[Score]
) < [Target]
&& SUMX (
FILTER (
ALL ( 'Table' ),
'Table'[Week] = _MAX - 1
&& 'Table'[Employee] = MAX ( 'Table'[Employee] )
),
'Table'[Score]
) < [Target]
&& SUMX (
FILTER (
ALL ( 'Table' ),
'Table'[Week] = _MAX - 2
&& 'Table'[Employee] = MAX ( 'Table'[Employee] )
),
'Table'[Score]
) < [Target],
1
)
Get the result.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi v-yanjiang-msft , appreciate the time you alloted on this inquiry. I'm not sure though what does the 3 consecutive column do? What I want to know is to identify which employee has a.) 3 consecutive weeks with below target score (ex. 2.75). Also not sure what is the value you've set for [TARGET]. Please advise. Thank you.
- v-yanjiang-msft
Hi nftgamesendaya ,
I just want to show which employee has reached the limit. Certainly you can change it to yes or no
Target is a measure to show the certain value like 2.75 in your example.
You can alse download my pbix. file I attached below to see more details.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.