Forum Discussion
Help with multiple entries from users and unique values
Not 100% sure I understand the ask. But, if you add the person responsible to a visual in Power BI, then create a measure as follows:
Activity Count = DISTINCTCOUNT(TableName[Activity])That will give you a distinct count of the activities for that user. So Mary will have 1 since she has "Activity 2" twice.
Not 100% sure I understand the ask. But, if you add the person responsible to a visual in Power BI, then create a measure as follows:
Activity Count = DISTINCTCOUNT(TableName[Activity])That will give you a distinct count of the activities for that user. So Mary will have 1 since she has "Activity 2" twice.
Thank you for your response!
This actially worked perfectly.
I was looking for an extra column while transforming data and did not think of a measure as suggested.
This allowed to me to count the total number of activities that Mary is pending to complete.
Thank you for your time!
