count each profile as 1 regardless of the number of stages they've gone through

[indranil36]

I need help with a specific problem.  I am extracting data from a dynamic spreadsheet which gets regular feeds for updates and additions in terms of rows

I have three specific Columns –

1. Name of the profile  
2. Stage of Operation ( 6 Stages)
3.  Number of profiles

Each profile goes through six different stages.  .. Whenever a profile enters a new stage of operation a new row gets generated against the same profile .

. Hence if we take the count of profiles using the column “ Number of Profiles”  - we get more than 1 count for one distinct profile name because he / she may have gone through different stages … Now for count of number of profiles , this should count as 1 ….

Please suggest a measure in DAX or Power query editor to hand the above scenario.

[indranil36]

Let me share with you some data, though the solution you gave might be of help. In the attached spreadsheet regardless of the status which might /might not change but gives rise to additional rows for the same profile for any work done related to a profile, my count of job openings should be considered as one if the " Job: Title" remains unchanged .. Need help on the DAX expression on the same  https://docs.google.com/spreadsheets/d/1PkBbJUzT3GWvofB66m0ivM6wAwGDE29P/edit?usp=sharing&ouid=10075... 

[AnthonyJoseph · Accepted solution]

@indranil36 Not sure if I understand your question. If you want to count the user profile only once irrespective of the number of rows the user profile is present? If yes, then you can use DISTINCTCOUNT('column name') in DAX meausre. If your requirement is not this, then please can you provide more details and show some sample input and output?