Forum Discussion
Solved
Flag a user based on few data points
I am creating a power bi report based on monthly survey data. One of the question is productivity gain. I want to identify users based on following criteria: Number of survey taken is greater than ...
Hi,
PBI file attached.
Hope this helps.
Hello PoojaG,
Can you please try this:
1. Count Surveys per User
Survey Count = COUNTROWS('Survey')
2. Flag Users Based on Criteria
Flag Super User =
VAR CurrentUser = 'Survey'[User]
VAR SurveyCount = CALCULATE(COUNTROWS('Survey'), FILTER('Survey', 'Survey'[User] = CurrentUser))
VAR FirstProductivity = CALCULATE(MIN('Survey'[productivity]), FILTER('Survey', 'Survey'[User] = CurrentUser), ALL('Survey'))
VAR LastProductivity = CALCULATE(MAX('Survey'[productivity]), FILTER('Survey', 'Survey'[User] = CurrentUser), ALL('Survey'))
RETURN
IF(SurveyCount > 2 && LastProductivity >= FirstProductivity, "Y", "N")
Hope this helps.
this solution may not consider all the in between survey results. only the first and the last.